Forum Discussion

bhaskarpbi999's avatar
bhaskarpbi999
Icon for Helper V rankHelper V
1 year ago
Solved

Card Visual not showing correct values after excluding dimension column

Hi ,   I have an issue with card visual where Rev Difference is not showing correct values after customer name is excluded from table visual.   Correct data       Incorrect data is disp...
Need Help
FBergamaschi's avatar
FBergamaschi
Icon for Super User rankSuper User
1 year ago

Hi bhaskarpbi999,

can you specify what is the nature of the measure GR Flag M, I need to reproduce that behaviour in another way 

Thanks

bhaskarpbi999's avatar
bhaskarpbi999
Icon for Helper V rankHelper V
1 year ago

Hi FBergamaschi,

 

I have created GR FLagM bco'z i cant use the measure logic IF([Rev cy] > [Rev Ly], 1, 0) and use it directly in slicer due to power BI feature restriction.

 

I used GR FlagM measure and filtering it using GR flag slicer which is number column from Flag slicer table and specified the logic in the below formula.

 

GR FlagM = VAR Test = IF([Rev cy] > [Rev Ly], 1, 0)
RETURN
     IF(ISFILTERED('Flag Slicer'[Number]),
     IF((Test= SELECTEDVALUE('Flag Slicer'[Number])),1,0),0)
       
When you select GR flag slicer value then only it will display data else no data.
Thanks for your support and if there is a alternative way that would be really helpfull for this issue.
 
Regards,
Bhaskar