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.
Dear All,
Based on the below data I need another column named Percentage that calculates percentage as (Sum of 4 & 5 / Total ) * 100.
The below table is a matrix table. Kindly help.
@v-jianboli-msft Please help me.
Solved! Go to Solution.
I found a resolution to this as below:
Measure =
VAR Count45_ = CALCULATE (
COUNT ( VW_DetailLookUp[Response] ),
FILTER (
ALLEXCEPT ( VW_DetailLookUp, VW_DetailLookUp[FileLocation], VW_DetailLookUp[Questions] ),
OR ( [Response]="4-Agree", [Response]="5-StronglyAgree" )
))
VAR CountAll_ = CALCULATE (
COUNT ( VW_DetailLookUp[Response] ),
ALLEXCEPT ( VW_DetailLookUp, VW_DetailLookUp[FileLocation], VW_DetailLookUp[Questions] ))
RETURN
IF (SELECTEDVALUE ( ResponseMaster[Response] ) = "Sum of 4 & 5",
Count45_,
IF (SELECTEDVALUE ( ResponseMaster[Response] ) = "Percent",
DIVIDE(
Count45_,
CountAll_, 0
) * 100,
COUNT ( VW_DetailLookUp[Response] )
))
I found a resolution to this as below:
Measure =
VAR Count45_ = CALCULATE (
COUNT ( VW_DetailLookUp[Response] ),
FILTER (
ALLEXCEPT ( VW_DetailLookUp, VW_DetailLookUp[FileLocation], VW_DetailLookUp[Questions] ),
OR ( [Response]="4-Agree", [Response]="5-StronglyAgree" )
))
VAR CountAll_ = CALCULATE (
COUNT ( VW_DetailLookUp[Response] ),
ALLEXCEPT ( VW_DetailLookUp, VW_DetailLookUp[FileLocation], VW_DetailLookUp[Questions] ))
RETURN
IF (SELECTEDVALUE ( ResponseMaster[Response] ) = "Sum of 4 & 5",
Count45_,
IF (SELECTEDVALUE ( ResponseMaster[Response] ) = "Percent",
DIVIDE(
Count45_,
CountAll_, 0
) * 100,
COUNT ( VW_DetailLookUp[Response] )
))
@Arul I did create another measure. But it does not work as expected.
As in the below figure, I need the percentage calculated based on [Sum of 4 or 5] / Total.
Also, the below figure gives an idea of the measure I already have.
Kindly help.
check this thread, this might help you.
Thanks,
Arul
try this,
Percentage =
VAR _allValues = CALCULATE(
SUM(Table[columnvalue]),ALL(table))
VAR _result = DIVIDE([Sum of 4 & 5],_allValues)*100
RETURN _result
Thanks,
Arul
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 |
---|---|
100 | |
99 | |
76 | |
66 | |
61 |
User | Count |
---|---|
142 | |
106 | |
103 | |
85 | |
70 |