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.
Is it possible to sum together the outputs of a measure?
I have a table popualted with measures (image below), and conditionally formatted (Red = 50, Yellow = 75 and Green = 100).
I'd like to create an overall result for each column - sum the outputs (eg. 250), and divide by the number of rows (3). This output i'll also conditionally format into a Red, Amber or Green result.
For an example of what each measure looks like, below is the first column.
TS_TSUtilisation_Score =
IF(ISBLANK([InvoiceCount]),0,
IF([FMO_TSUtil_Measure]="N",25,
SWITCH(TRUE(),
[TS_TSUtilisation]="Y",100,
CALCULATE(COUNT(APAll[TS_TSUtilisation_InProgress]),APAll[TS_TSUtilisation_InProgress]="Yes")>0,75,
[TS_TSUtilisation]="N",50,0)))
Hi @StidifordN
You could sum measures with SUMX dax function.
https://docs.microsoft.com/en-us/dax/sumx-function-dax
If you have any problem to get correct result, please share some simple data.
Best Regards
Maggie
@StidifordN , In the Matrix conditional formatting you an option to show icon.
https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
there is also an option to show only icon
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 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |