The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
36 | |
14 | |
12 | |
7 | |
7 |