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

July 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more

Reply
flemingg62
Helper I
Helper I

Using a Measure as a row

Hi I need to count how often a measure occues in a data set and produce a graph

I want to count Colum C against colum M which is a measure

flemingg62_0-1668449215522.png

 

To produce a graph like this

flemingg62_1-1668449288940.png

 

I tried to attached the pbix file but can't see how, so email me at [email protected] and I'll forward it

 

 

 

1 ACCEPTED SOLUTION
flemingg62
Helper I
Helper I

Tks, It looks like the solution.I try and get my head around and give it a go

View solution in original post

2 REPLIES 2
flemingg62
Helper I
Helper I

Tks, It looks like the solution.I try and get my head around and give it a go

Greg_Deckler
Community Champion
Community Champion

@flemingg62 In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick...



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Fabric Community Sticker Design Challenge Barcelona Carousel

Fabric Community Sticker Challenge - Barcelona 2026

If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!

July Power BI Update Carousel

Power BI Monthly Update - July 2026

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

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors