Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
How can I get the following measure to total? It is already formatted as a number but will not total.
Solved! Go to Solution.
Try something like that
HIPAA =
iferror(
sumx('Quotes',If(search("HIPAA",'Quotes'[Legal],1,0)>0,1,0)),
0) //edited
Try something like that
HIPAA =
iferror(
sumx('Quotes',If(search("HIPAA",'Quotes'[Legal],1,0)>0,1,0)),
0) //edited
I tried this and it adds the total to every row but not the grand total. Each row shows 49 no matter what filter I put on @amitchandak
@amitchandak Disregard my comment, I was using a calculated column and not a measure. It works perfectly as a measure, fyi there was a comma missing before the last 0 to anyone looking at this solution.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
89 | |
88 | |
82 | |
64 | |
49 |
User | Count |
---|---|
125 | |
111 | |
88 | |
69 | |
66 |