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 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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors