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 all,
I am trying to create a visual which counts the number of distinct rows that are displayed on the matrix shown above.
Please note I have the measure in the matrix filters (distinctcount) to only show me rows that have different values in each date column (hopefully clearly shown)
E.g. There are rows which have the same data across the dates and therefore they are hidden.
Does anyone know how I can count the number of distinct rows showing based on the date range selected?
Full data sat can be found Below
pbix file: https://we.tl/t-vd5jYugdD6
Solved! Go to Solution.
Attributes with Changes =
var a = summarize('Project Risks Query-xxx','Project Risks Query-xxx'[Attribute],'Project Risks Query-xxx'[Risk ID],"ch",DISTINCTCOUNT('Project Risks Query-xxx'[Value]))
var b = summarize(filter(a,[ch]>1),[Attribute])
return countrows(b)
see attached
Please provide sanitized sample data that fully covers your issue.
Attributes with Changes =
var a = summarize('Project Risks Query-xxx','Project Risks Query-xxx'[Attribute],'Project Risks Query-xxx'[Risk ID],"ch",DISTINCTCOUNT('Project Risks Query-xxx'[Value]))
var b = summarize(filter(a,[ch]>1),[Attribute])
return countrows(b)
see attached
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.