Forum Discussion
PBI_Monkey
Helper I
Helper IMeasure Total in Table not Showing
Hi All, I have a table with 2 measures. The one measure called 'Num Twice' is not showing the Total at the bottom of the table. https://www.dropbox.com/s/gv6tt6qyp140574/Total%20Not%20Showi...
Num Twice = SUMX( VALUES(Sheet1[ID]), CALCULATE( IF([Num PC] < 1, Sheet1[Total Contacts]), Sheet1[Contact Type] = "Twice" ))
SpartaBI
Community Champion
Community Champion
Num Twice =
SUMX(
VALUES(Sheet1[ID]),
CALCULATE(
IF([Num PC] < 1,
Sheet1[Total Contacts]),
Sheet1[Contact Type] = "Twice"
))