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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors