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 September 15. Request your voucher.
I have a line graph having three fields and each fileds are measures. I have created once slicer and usecd a different field in the slicer have to filter one of the field in the slicer and rest two fields should me unchanged.Means slicer shuld not affect other two fields
If you add the REMOVEFILTERS function to the other two measures, that should solve your problem. Within the REMOVEFILTERS function, you would add in the columns that your slicers reference.
Suppose if we choose any country only deduction field should change."costnn field should be unchanged
User | Count |
---|---|
65 | |
62 | |
60 | |
53 | |
28 |
User | Count |
---|---|
181 | |
82 | |
67 | |
47 | |
44 |