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
Super UserHi, 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.
Helper VHi MasonMA,
I have implemented the suggested formula but some how it's not working.
The issue when we ahve customer name with GR Flag slicer applied the value is 2169.
After removing customer name the value is 1984 and GR flag slicer also not working
Could you please help if i can modify formula to get the value for Rev CYand LY.
I have prepeared .pbix file with sample data but some how unable to upload file.
Regards,
Bhaskar
- bhaskarpbi999
Hi MasonMA,
The logic used for GRFlagM is the below formula.
GR FlagM = VAR Test = IF([Rev cy] > [Rev Ly], 1, 0)RETURNIF(ISFILTERED('Flag Slicer'[Number ]),IF((Test= SELECTEDVALUE('Flag Slicer'[Number ])),1,0),0)Regards,
Bhaskar
- MasonMA
Could you upload your sample data in Google drive. otherwise it's all based on assumptions:)
- bhaskarpbi999
Hi MasonMA,
Thanks and Kudos foryour support
Below is the google drive link.
https://drive.google.com/file/d/1H8NAIdUEQf2mEb6ZpAONztJOX38d9ZDB/view?usp=drivesdk
Regards,
Bhaskar