Forum Discussion
NvdVeerdonk
7 years agoFrequent Visitor
Visual problem by showing total
I have a problem. I made a visual in that visual are 2 colomns named Tarief and Totaal van Categerie. No is my problem that i want to show the totals of those two after they multiplied with for...
- 7 years ago
hi, NvdVeerdonk
For your case, try this formula
Measure = CALCULATE(SUMX('Tarieven 02','Tarieven 02'[Tarief]*CALCULATE(COUNTA('20190508 0916 export'[Categorie]))))Result:
Best Regards,
Lin
NvdVeerdonk
7 years agoFrequent Visitor
Hi v-lili6-msft,
I'm just learning Power BI.
How can i send you the sample?
i can share the data whit you but i need your E-mail ore you can requested an acces to the data:
Let me know what i have to do.
Best Regards,
Van de Veerdonk
v-lili6-msft
7 years agoCommunity Support
hi, NvdVeerdonk
You can upload it to OneDrive and post the link here.
or send link just by private letter.
Do mask sensitive data before uploading.
Best Regards,
Lin
- NvdVeerdonk7 years agoFrequent Visitor
- v-lili6-msft7 years agoCommunity Support
hi, NvdVeerdonk
For your case, try this formula
Measure = CALCULATE(SUMX('Tarieven 02','Tarieven 02'[Tarief]*CALCULATE(COUNTA('20190508 0916 export'[Categorie]))))Result:
Best Regards,
Lin