Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I need a measure to give me if this site was removed or not. In this case the site is not removed, because in March it´s "N".
But if the Max date is "Y" this should count as 1 removed site.
I have this calculation but it´s wrong.
Can you help me it this?
Thanks in advance
Try this @rmeng
Site Removed Count =
CALCULATE(
DISTINCTCOUNT(Sites[Site ID]),
Sites[Site Removed] = "Y"
)
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingSorry for the late reply, the result should be 0 on my table because the result looks at the max date and if it is Y then the result is 1 if not 0.
The example has the same ID for the 4 rows, you example is correct but you´re comparing different single ID.
Thanks
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
11 | |
11 | |
10 | |
6 |