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.
( [A. SumITSS] / [A. SumReq] ) * 100 //This is the primary measure
CALCULATE (
[A. CountITSS],
FILTER (
ALL ( DateTable ),
DateTable[Date] <= MAX ( DateTable[Date] )
&& NOT ( ISBLANK ( DateTable[Date] ) )
)
)
CALCULATE (
COUNT ( sc_req_item[u_initiating_medium] ),
FILTER ( sc_req_item, sc_req_item[u_initiating_medium] = "IT Self Service" )
)
SumReq =
CALCULATE (
[A. CountReq],
FILTER (
ALL ( DateTable ),
DateTable[Date] <= MAX ( DateTable[Date] )
&& NOT ( ISBLANK ( DateTable[Date] ) )
)
)
COUNT ( sc_req_item[u_initiating_medium] )
Just starting out with Power BI
It’s taking five measures just to create "the percentage of requests for "IT Self Service" for one graph below.
How can I simplify this into one measure?
Also I’d like to create 3-line graphs "Previous Qtr", "Current Qtr" and a 15-month running trend.
Is there a way to have a dynamic card showing the total percentage for their respective Qtr or 15 months? The one in the graph is static “Card” so even if you change the number of months it'll always show the same.
Solved! Go to Solution.
You can use variables to calculate multiple values in a single measure, and then use them to get a final result.
Use variables to improve your DAX formulas - DAX | Microsoft Docs
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
You can use variables to calculate multiple values in a single measure, and then use them to get a final result.
Use variables to improve your DAX formulas - DAX | Microsoft Docs
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |