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

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
Helper V
1 year ago

Hi FBergamaschi,

Thanks and kudos for your support 

 

 

Regards,

Bhaskar

  • FBergamaschi's avatar
    FBergamaschi
    Super 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
      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

         

         

    • bhaskarpbi999's avatar
      bhaskarpbi999
      Helper 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