Forum Discussion
All Page Filter not working as expected
I have multiple tables joined with many to many relation on Business unit. Also, I have created a all page filter of Business unit but on few charts if I apply the all page filter on Business unit it...
Pushpendra_S_R , Your two measures giving some data for those rows. Are they using coalesce, 1+ Divide() or divide() -1
If you measure divide(a,b) -1 then change it to divide(a-b,b) and try
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
amitchandak, not using any of the above mentioned method, my measure is as followed
Measure =
IF(ISFILTERED(Units[Units]) == FALSE,
FORMAT(sum(Table[Field]),"##,###,###,###"))
& IF(SELECTEDVALUE(Units[Units]) == "Billion",
FORMAT(sum(Table[Field])/SUM(Units[Values]), "##,###,###,###" & "B" ))
& IF(SELECTEDVALUE(Units[Units]) == "Million",
FORMAT(sum(Table[Field])/SUM(Units[Values]), "##,###,###,###" & "M" ))
& IF(SELECTEDVALUE(Units[Units]) == "Thousand",
FORMAT(sum(Table[Field])/SUM(Units[Values]), "##,###,###,###" & "K" ))