Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I add a slicer for amount range, increment value =200, then I add visual for Amount and Count, how to let Amount and Count dymanic change by range?
eg: if range = 1400, then display total amount and total count where amount is equal or less than 1400.
if range = 2000, then display total amount and total count where amount is equal or less than 2000.
Solved! Go to Solution.
If you need to filter the amount column
Countrows(filter(Table, Table[Amount] <= selectedvalue(whatif[value]) ))
Amount m=
calculate( Sum(Table[Amount]), filter(Table, Table[Amount] <= selectedvalue(whatif[value]) ))
If you need to filter the amount column
Countrows(filter(Table, Table[Amount] <= selectedvalue(whatif[value]) ))
Amount m=
calculate( Sum(Table[Amount]), filter(Table, Table[Amount] <= selectedvalue(whatif[value]) ))
Thank you very much, it resoved my question😀
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |