Forum Discussion
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 formule:
Tarief * Totaal van Categorie. How can i do this.
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
7 Replies
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/547907Then 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
