Forum Discussion
Helper VCard Visual not showing correct values after excluding dimension column
yes, here it is
https://drive.google.com/drive/folders/1FHc79P-25eVq8-K2a5c4uoPJ0_5wa6-w?usp=sharing
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
Hi bhaskarpbi999,
Thank you for reaching out to the Microsoft fabric community forum.
The issue you are facing is happening because your current Rev Diff calculation is using either VALUES() or a row-level context logic that works fine when Customer Name is part of the visual. But when you remove Customer Name like in a card visual, the calculation behaves differently and results in an incorrect total.
To fix this, you can modify the measure to remove the customer-level filter while still calculating the correct sum.
I tested it with my sample data, and it worked fine. Please find the attached screenshot and Pbix for your reference.
Hope the above provided information help you resolve the issue, if you have any further concerns or queries, please feel free to reach out to us.
Regards,
Harshitha.
- MasonMA
Super User
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..
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
bhaskarpbi999Hi hjannapu,Thanks for your support.i am not using customer name and revenue from same tables.Customer name from Account parent tableRev Raw from DWH_ADJ tableAnd the relationships are like below flow defined path is DWH_ADJ --> Account --> AccparentI 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
