cancel
Showing results for
Did you mean:

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a \$100 discount. Register Now

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!

1 ACCEPTED SOLUTION
Super User

Hi

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

@kldefens

3 REPLIES 3
Super User

Hi

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

@kldefens

Resolver III
Frequent Visitor

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.

Announcements

#### Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

#### Power BI Monthly Update - February 2024

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

#### Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

#### Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors