The column CC_Int CSIP and CC_Int deliver the same Total? How? The last two number in CC_Int is not in CC_Int CSIP and anyway the total is the same???????? NOG
Anonymous
8 years agoNot applicable
NOG,
Please create a new measure using DAX below , drag the measure to the visual and check the total value.
Measure = IF(COUNTROWS(VALUES('fact Controller Monthly Report'[CY/Mth]))=1, [CC_Int],SUMX(VALUES('fact Controller Monthly Report'[CY/Mth]),[CC_Int]))
Regards,
Lydia