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
MasonMA's avatar
MasonMA
Icon for Super User rankSuper User
1 year ago

Anonymous 

 

You really should have validated your results before you post it... This is from your file and your 'Rev Diff Correct' measure returns 32M? I'm terrified.. 

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi MasonMA,

Apologies for the confusion earlier, and thank you for pointing it out.

I reviewed the issue again, and you are right the previous explanation was incorrect. bhaskarpbi999 Please consider the below updated explanation as the correct one.

I have implemented the fix for the Rev Difference measure so that the card visual now calculates the correct total, even when the Customer Name dimension is excluded.

The result matches the sum of the customer-level differences shown in the table visual, as expected.
For your reference, I’m attaching a .pbix file.

Thank you

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

     

    Hi hjannapu,
    Thanks for your support.
    i am not using customer name and revenue from same tables.
    Customer name from Account parent table
    Rev Raw from DWH_ADJ table
    And the relationships are like below flow defined path is  DWH_ADJ --> Account --> Accparent
     

     

    I have tried with slicer but if i remove customer name and the value is not changing as per selection.

     

    Could you please suggest any alternate solution or formual for this issue.

     

    Regards,

    Bhaskar

     

     

     

     

     
     
     
    Preview
     
     
     
     
     
    Preview
     
     
     
    • MasonMA's avatar
      MasonMA
      Icon for Super User rankSuper User
      1 year ago

      bhaskarpbi999 

      Hi, based on your pictures, could you enable 'Bi-directional Filtering' ? (even though it's not recommended at model level, it might be a simpler solution. )

       

      What i see from your pictures is when the visual doesn’t include Customer Name, the context from AccountParent doesn’t propagate down to DWH_ADJ table. 

       

      If you wouldnt want to change the filtering direction, you may try with TREATAS as below. Again without looking at your pbix file and data validation, i cannot guarantee it works 100% 

      Rev Diff FIXED =
VAR Customers =
    VALUES('AccountParent'[Customer Name])
RETURN
    SUMX(
        TREATAS(Customers, 'AccountParent'[Customer Name]),
        CALCULATE([Rev CY]) - CALCULATE([Rev LY])
    )

       

      Please let me know if it works, thanks. 

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

        Hi MasaonMA,

        Thanks and kudos for your support.

        I am trying to implement suggetsed solution and will keep updated on this issue.

         

        Regards,

        Bhaskar