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.
Hello everyone,
Thanks in advance for your help. The last row is the formula that needed to be calculated. Any help is apprecaited.
Neg | Neg Percent Of Total Tested | Pending | Pending Percent Of Total Tested | Pos | Pos Percent of Total Tested | Pos Percent Of Known Results | Total tested | |
Test 1 | 2334 | 49.02 | 165 | 3.47 | 2262 | 47.51 | 49.22 | 4761 |
Test 2 | 228 | 47.01 | 16 | 3.3 | 241 | 49.69 | 51.39 | 485 |
Total | 2562 (B7) | 48.84 | 181 (D7) | 3.45 | 2503 (F7) | 47.71 | 49.42 | 5246 (I7) |
SUM | Cell B7/I7 (2562/5246) | SUM | Cell D7/I7 (181/5246) | SUM | Cell F7/I7 (2503/5246) | Cell F7/(F7+B7) (2503/2503+2562) | SUM |
Solved! Go to Solution.
hi @nanchil
For SUM calculation, you could just drag the field into visual directly,
for Percent measure, you could create this measure as below:
Measure Neg Percent Of Total Tested =
DIVIDE (
CALCULATE ( SUM ( 'Table'[Neg] ) ),
CALCULATE ( SUM ( 'Table'[Total tested] ) )
)
Measure Pending Percent Of Total Tested =
DIVIDE (
CALCULATE ( SUM ( 'Table'[Pending] ) ),
CALCULATE ( SUM ( 'Table'[Total tested] ) )
)
Measure Pos Percent Of Known Results =
DIVIDE (
CALCULATE ( SUM ( 'Table'[Pos] ) ),
CALCULATE ( SUM ( 'Table'[Pos] ) )+CALCULATE(SUM('Table'[Neg]))
)
Measure Pos Percent of Total Tested =
DIVIDE (
CALCULATE ( SUM ( 'Table'[Pos] ) ),
CALCULATE ( SUM ( 'Table'[Total tested] ) )
)
Result:
and here is sample pbix file, please try it.
Regards,
Lin
hi @nanchil
For SUM calculation, you could just drag the field into visual directly,
for Percent measure, you could create this measure as below:
Measure Neg Percent Of Total Tested =
DIVIDE (
CALCULATE ( SUM ( 'Table'[Neg] ) ),
CALCULATE ( SUM ( 'Table'[Total tested] ) )
)
Measure Pending Percent Of Total Tested =
DIVIDE (
CALCULATE ( SUM ( 'Table'[Pending] ) ),
CALCULATE ( SUM ( 'Table'[Total tested] ) )
)
Measure Pos Percent Of Known Results =
DIVIDE (
CALCULATE ( SUM ( 'Table'[Pos] ) ),
CALCULATE ( SUM ( 'Table'[Pos] ) )+CALCULATE(SUM('Table'[Neg]))
)
Measure Pos Percent of Total Tested =
DIVIDE (
CALCULATE ( SUM ( 'Table'[Pos] ) ),
CALCULATE ( SUM ( 'Table'[Total tested] ) )
)
Result:
and here is sample pbix file, please try it.
Regards,
Lin
@nanchil , we are not seeing excel cells here, so not very clear.
Can you share sample data and sample output.
Thanks ! the first two rows are the sample data. The third row is the total that is calculated. The fourth row is the formula that is used to arrive the third row,.
@nanchil Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |