Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have one question about aggregation in Power BI:
My Measure =
Solved! Go to Solution.
Hi Amit,
Thanks, it really works well.
Just one more thing I am getting the table correct , is there a way to get the total at the bottom.
@Priya2007 , Try a measure like
sumx(values(Table[id]),If([SAI]> [SAI liM]*.7 || [SAF]>[SAFLimit]*.7,1,0))
or
sumx(summarize(Table[id],"_1",If([SAI]> [SAI liM]*.7 || [SAF]>[SAFLimit]*.7,1,0)),[_1])
Hi Amit,
Thanks, it really works well.
Just one more thing I am getting the table correct , is there a way to get the total at the bottom.
User | Count |
---|---|
47 | |
26 | |
22 | |
17 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |