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.
Hi,
have a report 2 visuals
one a card visual and has
shows 6
and have a table visual which shows the 6 rows.
When try show this (DISTINCTCOUNT('table'[col])) shows as 1 on each row rather than 6 presumably as evaulating at row level rather than shpwing the total in report which 6.
How can we have a variabale which shows this (DISTINCTCOUNT('table'[col])) on each row of the table so evaluate at report leve rather than row level?
Thanks
Solved! Go to Solution.
@po , try one of the two options
calculate(DISTINCTCOUNT('table'[col]), allselected('table'))
or
calculate(DISTINCTCOUNT('table'[col]), all('table'))
@po , try one of the two options
calculate(DISTINCTCOUNT('table'[col]), allselected('table'))
or
calculate(DISTINCTCOUNT('table'[col]), all('table'))
Thanks for response
User | Count |
---|---|
95 | |
89 | |
70 | |
63 | |
58 |
User | Count |
---|---|
149 | |
113 | |
95 | |
80 | |
72 |