Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
kldefens
Frequent Visitor

How do I calculate an extra colomn of Percentage of Grand total with dax


Hello guys,

In the third colomn you can see the  % of GT, this is done by "show value as".

I want this in a measure so I could calculate some formulas.

 

The column "Total90%FilterCalculate" is created with this measure:

Total90%FilterCalculate = CALCULATE(DISTINCTCOUNT(MKA[Versies.Id]), FILTER(MKA, MKA[VullingTotaalPerc]="90 %"))


How do I create this measure?

Thnx!
kldefens_0-1670800827714.png

 

1 ACCEPTED SOLUTION
FreemanZ
Super User
Super User

Hi   

try like:
Pct =
VAR _Total=
CALCULATE(
    DISTINCTCOUNT(MKA[Versies.Id]),
    ALL(MKA)
)
RETURN
FORMAT(DIVIDE([Total90%FilterCalculate], _Total), "0.0%")

@kldefens

View solution in original post

3 REPLIES 3
FreemanZ
Super User
Super User

Hi   

try like:
Pct =
VAR _Total=
CALCULATE(
    DISTINCTCOUNT(MKA[Versies.Id]),
    ALL(MKA)
)
RETURN
FORMAT(DIVIDE([Total90%FilterCalculate], _Total), "0.0%")

@kldefens

grandtotal
Resolver III
Resolver III

I've tried to do the same thing but I get an error. I don't know how to use the measure whenever I use distinccount + filter.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.