Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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