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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
kldefens
Frequent Visitor

How to prevent the measure result splitting over all the departments in a clustered column chart?

Hi guys,

I have created a clusterd column chart with the departments on the Axis. 
The value of the clusterd column chart is a measure where I calculate the count of unique values in the column "Versies.Id" of the table "MKA", but only for those rows where the column "VullingProductTbbRubricering hh" is not blank. 

The measure is: 

ALLE-GII = CALCULATE(
DISTINCTCOUNT(MKA[Versies.Id]),
MKA[VullingProductTbbRubricering hh] <> BLANK()
)


What I want now is that the total result of the measure "ALLE-GII" will be added only to one department "GII" and will not split over alle the different department. How can I do that? See picture below for how the column chart is looking right now.

kldefens_0-1676311056073.png

 

 

 

 

1 REPLY 1
Anonymous
Not applicable

It is hard to follow what you want to achieve without sample data.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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

Top Kudoed Authors