The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I have a calculation group made in Tabular Editor. I use it for display units and it works fine on my measures. But when i do a Percentage calculation, it should not work on those measures. I have tried to use removefilters() on my percentage measure, but it doesn't have any effect. Is there some way i can add the filter in my calculation groups table, so it doesn't affect this percentage filter?
I use the selectedmeasure() just in my calculation group. Hope somebody can help with this.
Related to AmiraBedh's post, Alberto did a short vid on it: ISSELECTEDMEASURE – DAX Guide - SQLBI
I think I am trying to do the same thing you are and it worked like a charm.
Try to use `ISSELECTEDMEASURE` function within your calculation group's table. It allows you to check whether a specific measure is currently selected and apply different logic based on the result.
Here's an example of how you can use the `ISSELECTEDMEASURE` function in the calculation group table to exclude measures from the calculation group's effects:
Here's an example :
MyPercentageMeasure :=
IF ( ISSELECTEDMEASURE ( 'MyModel'[MyPercentageMeasure] ), 'MyModel'[MyPercentageMeasure], BLANK() )
This formula checks if "MyPercentageMeasure" is selected and returns its value. If it is not selected, it returns BLANK().
@Anonymous , Based on what I got , you have to create another calculation group like
Divide([selected measure], calculate([selected measure], removefilters(Table) ) )
User | Count |
---|---|
74 | |
70 | |
39 | |
30 | |
28 |
User | Count |
---|---|
104 | |
95 | |
51 | |
48 | |
46 |