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.
Hi
How to i remove the value ""Aged Debt < 30 Days" from the table below?
It is coming from the Switch Measure that i have created at the top of the SNIP image
@Sean-OReilly Well, either filter it out in the Filters pane or remove the 4th line down from your measure.
Thanks for your reply @Greg_Deckler
Removing the 4th line won't work - it just adds a different value into the total column.
Does adding something like HASONEVALUE to the measure fix this type of problem?
If so, what does the measure look like?
User | Count |
---|---|
15 | |
13 | |
9 | |
6 | |
6 |
User | Count |
---|---|
29 | |
19 | |
13 | |
8 | |
5 |