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, How do I perform a count of the Cons group in each specific reporting unit. The output I am trying to achieve is in green:
Solved! Go to Solution.
pls add all(), and have a try on below DAX.
calculate(distinctcount[consgroup],filter(ALL(table),[reportingunit]=max([reportingunit]))
Proud to be a Super User!
maybe try
calculate(distinctcount[consgroup],filter(table,[reportingunit]=max([reportingunit]))
Proud to be a Super User!
pls add all(), and have a try on below DAX.
calculate(distinctcount[consgroup],filter(ALL(table),[reportingunit]=max([reportingunit]))
Proud to be a Super User!
you are welcome
Proud to be a Super User!
@gracie494 Perhaps:
Measure =
VAR __RU = MAX('Table'[Reporting Unit])
VAR __CG = MAX('Table'[ConsGroup])
RETURN
COUNTROWS(FILTER(ALL('Table'),[Reporting Unit]=__RU && [ConsGroup]=__CG))
@gracie494 , Try
a New column
= calculate(distinctcount(Table[ConsGroup]), filter(Table, [ reporting unit] =earlier([ reporting unit])))
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 |
---|---|
86 | |
84 | |
66 | |
61 | |
59 |
User | Count |
---|---|
194 | |
111 | |
105 | |
79 | |
71 |