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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
aavacaflores
Regular Visitor

Measures not related to dimensions

In multidimensional models, there is a section "Dimension Usage" where you can define if a measure group is related to a dimension group. In case that it is not related, when you use the measure and dimension in Excel, it displays the column blank (much better than repeating random numbers :-))

Do you know if this behavior can be achieved in Power BI?

 

2021-04-24_17-18-41.jpg2021-04-24_17-22-40.jpg

1 ACCEPTED SOLUTION

You can achieve the same result in DAX writing this code for every measure:

IF ( ISFILTERED ( 'Transaction Type' ), BLANK(), <original measure> )

View solution in original post

2 REPLIES 2

You can achieve the same result in DAX writing this code for every measure:

IF ( ISFILTERED ( 'Transaction Type' ), BLANK(), <original measure> )

StefanoGrimaldi
Resident Rockstar
Resident Rockstar

yes, this can be done, using a external tool as tabular editor, here a quick tutorial explaining how to achive this: https://visualbi.com/blogs/microsoft/powerbi/leveraging-calculation-groups-power-bi/#:~:text=Calcula....

 

if this helped give some kudos, and mark as solved for others to find. 





Did I answer your question? Mark my post as a solution! / Did it help? Give some Kudos!

Proud to be a Super User!




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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