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.
Hi,
I want to get the number of rows where the offer of a selectedvalue is higher compared to the benchmark "Fozzie Bear".
PBIX:
https://1drv.ms/u/s!AsLM3f2rQCP34xv34CARLr8vZ0bv?e=NNzvVi
For example, if I select "Rizzo the Rat", then Count = 1, since
Project MPS: Fozzie Bear 433,015 > Rizzo the Rat 316,426
Project Disney World: Rizzo the Rat 449,034 > Fozzie Bear 256,240
However, the Measure Count shows
= 2
Any idea what to improve?
Kind regards
Chris
Solved! Go to Solution.
Hi @Chris_23 ,
Please try:
Count =
VAR _a =
SUMMARIZE (
'Table',
'Table'[Job],
'Table'[Vendor],
"Flag",
IF (
SUMX (
FILTER (
ALL ( 'Table' ),
[Job] = EARLIER ( 'Table'[Job] )
&& [Vendor] = "Fozzie Bär"
),
[Offer]
)
< SUM ( 'Table'[Offer] ),
1
)
)
RETURN
IF ( ISFILTERED ( 'Table (2)'[Vendor] ), SUMX ( _a, [Flag] ) )
Output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Chris_23 ,
Please try:
Count =
VAR _a =
SUMMARIZE (
'Table',
'Table'[Job],
'Table'[Vendor],
"Flag",
IF (
SUMX (
FILTER (
ALL ( 'Table' ),
[Job] = EARLIER ( 'Table'[Job] )
&& [Vendor] = "Fozzie Bär"
),
[Offer]
)
< SUM ( 'Table'[Offer] ),
1
)
)
RETURN
IF ( ISFILTERED ( 'Table (2)'[Vendor] ), SUMX ( _a, [Flag] ) )
Output:
Best Regards,
Jianbo Li
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |