Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to Solution.
You can achieve the same result in DAX writing this code for every measure:
IF ( ISFILTERED ( 'Transaction Type' ), BLANK(), <original measure> )
You can achieve the same result in DAX writing this code for every measure:
IF ( ISFILTERED ( 'Transaction Type' ), BLANK(), <original measure> )
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.
Proud to be a Super User!
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |