Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All
Can anyone help with this issue? Been searching for sometime but still cant find an answer.
So I generated below visual using measures. I need to count the no. of occurences of "Within range", "Overperform" and "Underperform" in the range column for below visual.
I tried to use fomulas like COUNT, but it seems that i need to reference to a column in a physical table, or some calculated column( which i cant add to the raw data as calculations would not work)
Is there any way to count from this visual directly?
Appreciate if anyone can advise.!
Solved! Go to Solution.
Hi,
These measures work
Measure = COUNTROWS(FILTER(VALUES(data[SKU]),[Range]="Within range"))
Measure 3 = COUNTROWS(FILTER(VALUES(data[SKU]),[Range]="Underperform"))
Measure 2 = COUNTROWS(FILTER(VALUES(data[SKU]),[Range]="Overperform"))
Hope this helps.
Hi,
Share the download link of your PBI file.
Hi, i created a sample data. You can download from below link
Many thanks for helping.
Hi,
These measures work
Measure = COUNTROWS(FILTER(VALUES(data[SKU]),[Range]="Within range"))
Measure 3 = COUNTROWS(FILTER(VALUES(data[SKU]),[Range]="Underperform"))
Measure 2 = COUNTROWS(FILTER(VALUES(data[SKU]),[Range]="Overperform"))
Hope this helps.
You are welcome.
@Munch00 what is Range? Is it a measure or a column?
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hi, it is the name of a measure. I created a sample file to illustrate what i need, you can refer to below link
Many thanks!
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |