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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
rmeng
Helper II
Helper II

Distinct Count Total

Hello,

I have a table with a measure  # TierJav = DISTINCTCOUNT(JAVELLIN[ACCOUNT_TIER]).

rmeng_0-1616607885559.png

The purpose is to have a measure to give me this result instead:

 
 

rmeng_4-1616608264318.png

That has the distinct count  of ACCOUNT_TIER added in row, removing filter context of Month_YEAR (ALL Function I suppose).

Month_YEAR is a column from DIM CALENDAR not from the Fact Table JAVELLIN.

Can you help me with this?

Thanks

 

 

 

 

 

5 REPLIES 5
Angith_Nair
Continued Contributor
Continued Contributor

Hi @rmeng ,

Try with this measure..

Measure =
CALCULATE ( DISTINCTCOUNT ( JAVELLIN[ACCOUNT_TIER] ), ALL ( DIMCALENDAR ) )

 

 

Sorry for the late response, but the result still bring 1 instead of 2 in #TierJav Measure.

I also though that could be the answer.

Angith_Nair
Continued Contributor
Continued Contributor

Could you please share the pbix file so that I can look into the issue...?

 

Sure, let me first create a new PBIX because this is sensitive data. Thanks

ERD
Community Champion
Community Champion

Hello @rmeng ,

You can use COUNTAX (<Table>, <Expression>) function with ALL:

#measure = COUNTAX(ALL(Table[Column]),Table[Column])

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.

Check out my latest demo report in the data story gallery.

Stand with Ukraine!


Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/

Thank you!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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