Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
71 | |
37 | |
21 | |
19 | |
15 |
User | Count |
---|---|
125 | |
34 | |
27 | |
25 | |
24 |