Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 formule:
Tarief * Totaal van Categorie. How can i do this.
Solved! Go to Solution.
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
hi, @NvdVeerdonk
For your case, just create a calculate measure by this formula:
Measure = CALCULATE(SUM('Table'[Tarief]))*CALCULATE(SUM('Table'[Totaal van Categerie]))
https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-measures
https://docs.microsoft.com/en-us/power-bi/desktop-measures
By the way: If you want the total of the measure is 407+133650= 134057 not 148916
You could see this post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Then for your case, use this measure formula:
Measure 2 = VAR _table = SUMMARIZE ( 'Table', 'Table'[Relatie], 'Table'[Categorie], "_total", CALCULATE ( SUM ( 'Table'[Tarief] ) ) * CALCULATE ( SUM ( 'Table'[Totaal van Categerie] ) ) ) RETURN SUMX ( _table, [_total] )
here is pbix file, please try it.
Best Regards,
Lin
Dear Lin,
Thank you for the answer. I understand the measure only it gifs an error because "Totaal van Categorie" isn't a kolom in a table. This the valuwe Categorie. so i can't find Totaal van categorie and when i use Categorie i can't use the measure anywere.
Best Regards,
Nicole
hi, @NvdVeerdonk
Which column are not numeric type?
Could you share your simple sample pbix file for us?
Best Regards,
Lin
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |