Forum Discussion

bhaskarpbi999's avatar
bhaskarpbi999
Helper 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
Super User
1 year ago

Hi bhaskarpbi999 and MasonMA,

while I was waiting for a feedback on the neture of the measure used as a filter, I tought to sove it differently

Now I have a file in which I implemented the new logic, where can I upload it so you can test it?

 

Here how it works now, a few screenshots

 

The totals stay correct if I remove the Customer:

 

 

With the flag on zero:

 

 

and still same totals if I remove the Customer

 

 

Is this what you were looking for?

 

Best

 

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

bhaskarpbi999's avatar
bhaskarpbi999
Helper V
1 year ago

Hi FBergamaschi,

Thanks and kudos for your support.

I have replied about the behavior of GRFlagM but i have seen yourolution  solution post and i am expecting the same result after customer name is removed.

 

Could you please share the test .pbix so that i can check it and see if it works fine with sclicer filter.

 

Thanks in Advance for your immense support.

Regards,

Bhaskar