The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I am trying to count how many TRUE() and FALSE() are resulting from the measure DidUserPurchaseInBoth Periods. All the values in the matrix are measures, no columns.
I have created this measure:
Hi @JolienR ,
According to your snapshot, when you use the formula of @davehus 's, why not put the measure in a card visual like your original post? As according to the context, if you put the measure in the visual, it will return 1 on rows where the DidUserPurchaseInBoth Periods is true. Or if you want to return the total number in each "true" row, modify the formula to :
Verloop individueel =
IF (
'MetingenKlanten'[DidUserPurchaseInBothPeriods] = TRUE (),
SUMX (
FILTER (
ALL ( MetingenKlanten ),
MetingenKlanten[DidUserPurchaseInBothPeriods] = TRUE ()
),
1
)
)
I can't access your attached file, and it get correct result in my created sample.
I attach my sample below for your reference.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-yanjiang-msft,
Many thanks for your reaction. Unfortunately, CustomerLast12-6Months & CustomerLast6-0Months are measures and I am not able to use the same measure for DidUsersPurchaseInBothPeriods as you did. Which results in the fact that Verloop invidueel still 1 is.
Hi @Luuky, & @davehus
Unfortunately, it does not work.
I uploaded a test file: https://drive.google.com/file/d/1xPceY0cWO3E6H-rBlE38gcA-ln35GNGD/view?usp=sharing
These measures are the I use:
Hi @JolienR ,
Try something like
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
94 | |
86 | |
70 | |
65 |
User | Count |
---|---|
244 | |
127 | |
119 | |
81 | |
78 |