Forum Discussion
Advocate ICard shows 0 value No filter applying IF Statement Measure
Hi Chipsnump
Here I create a measure:
MEASURE = VAR _vtable = SUMMARIZE ( 'Custoemr', 'Custoemr'[Group Name_2], "_ActSales", [Actual_Sales], "_Crteria", [Criteria 1] ) RETURN SUMX ( _vtable, [_Crteria] )Add it into a card, the result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi,
I do not know what result you want. Furthermore, when i opened the file, i got 10,000 as the answer in the card visual (not a 0). Anyways, drag this measure to the table and card visual
Measure = SUMX(VALUES(Custoemr[Group Name_2]),[Criteria 1])Hope this helps.
I made it, thank you so much for your kind support and advice 🙂
Hi Chipsnump
I may have misjudged, but this DAX code doesn't seem to be a problem.
Please share your data(exclude sensitive data) or create some sample data, so that we can help you better.
You can refer the following links to share the required info:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Advocate Ihi,
please find the pbix for your consideration. Normally, I would write the dax to set up the logic for the payment like this.
https://drive.google.com/file/d/1rWaEELvH8fTqyiEJ3TZXPRKQg5fVaoqC/view?usp=sharing
Hi Chipsnump
Here I create a measure:
MEASURE = VAR _vtable = SUMMARIZE ( 'Custoemr', 'Custoemr'[Group Name_2], "_ActSales", [Actual_Sales], "_Crteria", [Criteria 1] ) RETURN SUMX ( _vtable, [_Crteria] )Add it into a card, the result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.- Chipsnump
I made it, thank you so much for your kind support and advice 🙂
- Ashish_Mathur
Super User
Hi,
I do not know what result you want. Furthermore, when i opened the file, i got 10,000 as the answer in the card visual (not a 0). Anyways, drag this measure to the table and card visual
Measure = SUMX(VALUES(Custoemr[Group Name_2]),[Criteria 1])Hope this helps.
- Chipsnump
Thanks, it is working too 🙂
Cheer to this community. Thank you for your sharing.
- Ashish_Mathur
You are welcome.