Forum Discussion

Helper I

4 years ago

Solved

Measure 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...

Need Help

SpartaBI

4 years ago

PBI_Monkey

Num Twice = 
SUMX(
    VALUES(Sheet1[ID]),
    CALCULATE(
        IF([Num PC] < 1, 
        Sheet1[Total Contacts]),
            Sheet1[Contact Type] = "Twice"
))