Measure not showing totals in table

[john316swan]

I have a measure but it's not showing totals in the table totals at the bottom, here is the dax formula:

Total Packages =
CALCULATE(
COUNTROWS(CAMS),
CAMS[Awarded] = 1,
FILTER(
ALL('SF'),
'SF'[Jessup Program Type] = SELECTEDVALUE('SF'[Jessup Program Type]) &&
'SF'[Application Level] = SELECTEDVALUE('SF'[Application Level]) &&
'SF'[campus] = SELECTEDVALUE('SF'[campus])
)
)

 

[RoryA]

SELECTEDVALUE returns BLANK by default if there isn't one distinct value applicable, which is probably the case at the grand total level.

 

[john316swan]

SELECTEDVALUE returns BLANK by default if there isn't one distinct value applicable, which is probably the case at the grand total level.

How would I rewrite then to get the grand total?

 

[RoryA]

Why are you using SELECTEDVALUE in the measure?

 

[john316swan]

That was how I got the values to actually show, I'm a newb to pbi/dax and I am pulling data from Salesforce and a sql connection and after messing around that's how I was able to get the values to show in the table.

 

[RoryA]

What do you get with just:

Total Packages =
CALCULATE(
COUNTROWS(CAMS),
CAMS[Awarded] = 1)

 

[john316swan]

It gives the total regardless of the filters.

 

[RoryA]

That sounds like you possibly don't have the right relationships set up between the CAMS and SF tables.

 

[john316swan]

I feel like it's a pretty basic report, one-to-one relationship with only student id.

 

[RoryA]

That looks OK assuming you do have a 1:1 relationship. Any chance you can post a link to the pbix file?