Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone,
This task would normally be very easy to accomplish on excel, but I have having trouble with DAX.
I have a table which have multiple columns.
I have created a measure to find the KPI by using the Divide function on dax, so my KPI is a measure.
Now I have a table that has those KPI by month for the curent fiscal year and by location:
The value that you see is based on :
All I am trying to do is count rows when the KPI is lesser than .80.
So row 1 - 4 will show 0 (as all met the KPI), but row #5 will show 1 because KPI for that month July is 0.66. I want a total count for the rows in this year. On excel I would have just done "=COUNTIF(A1:M1,"<0.8").. Any guidance would grealy be appreciated.
Regards,
Solved! Go to Solution.
Hi @windykalra ,
You may create a measure like this:
Below =
COUNTROWS(
FILTER(
SUMMARIZE (
'table',
'Table'[Product],
'Table'[Month],
"Kpi",
[Kpi]
),
[Kpi] < 0.96
)
)
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @windykalra ,
You may create a measure like this:
Below =
COUNTROWS(
FILTER(
SUMMARIZE (
'table',
'Table'[Product],
'Table'[Month],
"Kpi",
[Kpi]
),
[Kpi] < 0.96
)
)
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |