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
bhaskarpbi999's avatar
bhaskarpbi999
Icon for Helper V rankHelper V
1 year ago

Hi Bergamasch.

I needs GR flagM measure as a slicer filter but we can"t use measure as a filter.

So if I need to use GRFlagM in slicer I have defined that logic.

 

But my client wants to filter and use RevDiff measure in charts with different dimensions but when use them like month wise and market segment wise not getting right numbers and I have issue to filter growing flag.. Thanks for your extreme support

 

FBergamaschi's avatar
FBergamaschi
Icon for Super User rankSuper User
1 year ago

It is enough the Force that measure to go one Customer at a time, I will fix it after dinner, ok?

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

    Hi FBergamaschi,

    Thanks and kudos for your support 

     

     

    Regards,

    Bhaskar

    • 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

      • FBergamaschi's avatar
        FBergamaschi
        Icon for Super User rankSuper 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