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.
Hey everyone,
Is there a way to count rows or distinctcount the articles where difference <0 ? Difference is a measure, based on several other measures.
I only need one return with 3 as result. I do understand that I can't use a card visual, because you can't aggregate when you want to filter on a measure. But isn't there a workaround?
Solved! Go to Solution.
Hello there @Anonymous ! Not sure if this is what you need but:
Measure =
CALCULATE(
COUNTROWS(
FILTER(
SUMMARIZE(
'Articles',
'Articles'[Aggregation_criteria],
"Diff", [Difference]
),
[Difference] < 0
)
)
)
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
You can also check out my LinkedIn!
Best regards,
Gonçalo Geraldes
Thank you guys! @goncalogeraldes , your suggestion worked perfectly, so I will be using that measure
You can use FILTER with a measure. As it is an iterator it will perform the check for each row of the given table, e.g.
Num < 0 = COUNTROWS( FILTER('Table', [Difference] < 0) )
and you should be able to use that on a card visual as well.
Hello there @Anonymous ! Not sure if this is what you need but:
Measure =
CALCULATE(
COUNTROWS(
FILTER(
SUMMARIZE(
'Articles',
'Articles'[Aggregation_criteria],
"Diff", [Difference]
),
[Difference] < 0
)
)
)
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
You can also check out my LinkedIn!
Best regards,
Gonçalo Geraldes
Let's assume there row filter context is from the column Table[Field] and the measure is [difference]
You can try:
Count Field =
COUNTX (
CALCULATETABLE ( VALUES ( Table[Filed] ), FILTER ( Table, [Difference] < 0 ) ),
Table[Field]
)
It should work in a card visual
Proud to be a Super User!
Paul on Linkedin.
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |