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,
I want to create a measure to show if the measure #Picks has a value of 5 or more.
#Picks = distinctcountnoblank(PickPerformance[pick_id]).
Next I tried the same, but I implemented the formula of the #Picks measure into the MoreThan5Picks Measure:
But the result was the same. Now I just don't know why it does not work.
Any ideas?
Hi @AlexEncuble think about granularity in your picture: you are showing the lowest level of data with measure definition below? If yes, as your measure return distinctcount per lowest level of data, then it is ok to receive only 1 or in your case with if >5 only 0.
Maybe you wanted measure to apply on higher level of data...
#Picks = distinctcountnoblank(PickPerformance[pick_id]).
Proud to be a Super User!
I don't know what you mean, if the Measure #Picks has more than 5 entries in this visual the measure MoreThan5Picks should have the value 1, else it should have the value 0.
Proud to be a Super User!
User | Count |
---|---|
17 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
12 | |
9 | |
8 |