Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everone
I have a two KPIs
this is their table
KPI Actual Planned
Revenue % 20% 30%
Saving Value 2454 3000
I want to use a table and have the values in both Percentage and Numbers but its not working i can only choose one !
can you help me please ?
Solved! Go to Solution.
hi, @Anonymous
After my test, you could do these as below:
Add two calculate measure for each column
New Actual = IF(SEARCH("%",SELECTEDVALUE('Table1'[KPI]),1,0)>0,FORMAT(CALCULATE(SUM('Table1'[Actual])),"0%"),CALCULATE(SUM('Table1'[Actual]))) New Planned = IF(SEARCH("%",SELECTEDVALUE('Table1'[KPI]),1,0)>0,FORMAT(CALCULATE(SUM('Table1'[Planned])),"0%"),CALCULATE(SUM('Table1'[Planned])))
Result:
here is pbix, please try it.
Best Regards,
Lin
hi, @Anonymous
After my test, you could do these as below:
Add two calculate measure for each column
New Actual = IF(SEARCH("%",SELECTEDVALUE('Table1'[KPI]),1,0)>0,FORMAT(CALCULATE(SUM('Table1'[Actual])),"0%"),CALCULATE(SUM('Table1'[Actual]))) New Planned = IF(SEARCH("%",SELECTEDVALUE('Table1'[KPI]),1,0)>0,FORMAT(CALCULATE(SUM('Table1'[Planned])),"0%"),CALCULATE(SUM('Table1'[Planned])))
Result:
here is pbix, please try it.
Best Regards,
Lin
This is Perfect,
Thanks alot Lin it worked like magic.
Hope you have a great day 🙂
Regards,
Abdulkareem
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
71 |