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.
HI
Trying to replicate the table below in Power BI
I have a USD column and a Project Health column. (Values can be "Green", "Red", "Orange", etc...)
The idea is to show total USD in one row and create another mesure called risk where only USD with Project health (RED and ORANGE) are included and extra row for % vs the total.
Tried different formulas but not really working.
Solved! Go to Solution.
@romovaro Use
Risk = CALCULATE(SUM('Weekly Slippage'[USD], FILTER ('Weekly Slippage', 'Weekly Slippage'[Project Health] IN {"Red" ,"Orange"}))
HI Mohan
Thanks for your help
Tried your formula but I get an error:
Too many arguments were passed to the SUM function. The maximum argument count for the function is 1.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |