Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi. I am trying to create a measure to exclude all values less than 5.
Would this be possible?
I tried to make this measure: Measure= if(COUNT('Antal'[Registrerings Dato])<5;"<5";format(count('Antal'[Registrerings Dato]);"")).
This made all values less than 5 be "<5" but it does not change the totals.
Hi @JimmyDQN,
What's the expected result?
1. If you want to exclude these items that have value "<5", you can try a measure like this:
Measure = SUMX ( 'Antal'; IF ( 'Antal'[Registrerings Dato] < 5; 0; 'Antal'[Registrerings Dato] ) < 5 )
2. If you want to exclude these items that have presence "<5", you can use your formula and filter them out in the visual level filter.
Or, you can share your data model and the expected result.
Best Regards,
Dale
Hi again @v-jiascu-msft
I can't get the measure to work.
The idea is to exclude items that have value "<5".
Registration dato is actually registration date, and it seems like the measure won't work.
Should I do a count initially? or perhaps do something differently? For instance, looking at this table. I won't to format the numbers to be <100 and not be accounted for in the totals. Is that possible?
Hi @JimmyDQN,
Could you please share a sample and the expected result?
Best Regards,
Dale
Hello.
I am trying to create a measure to remove numbers less than 5 from totals.
I created this measure: Measure1= if(COUNT('Antal'[Registrerings Dato])<5;"<5";format(count('Antal'[Registrerings Dato]);""))
This measure changes all values less than 5 to "<5" but you can still calculate the totals.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |