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 am looking for assistance please regards to the creation of 2 measures (to be used in card visuals) - one that displays a Count of Cost Centres (AB_CC) that are within budget, and another that displays the percentage of cost centres that are within budget. Please see below screenshot of an example table (ACCOUNT_BALANCES) to illustrate my issue:
From this table we can see the total variance for each cost centre is as follows:
So in total, 3 Cost Centres are under budget, which is 60% of all cost centres. These are the 2 measures I would like to formulate please if possible.
I have attempted some DISTINCTCOUNT and FILTER formulas, but in the case of the Count summation they keep returning a result of 4 which is incorrect.
Thank you
Solved! Go to Solution.
Pls try this
Proud to be a Super User!
Pls try this
Proud to be a Super User!
Yes that works, nice one ryan_mayu! Thank you
you are welcome
Proud to be a Super User!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
88 | |
85 | |
68 | |
68 | |
64 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |