The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All,
i have to display summary details in my report as below:
CategoryA | CategoryB | CategoryC | |
Overall | 150 | 200 | 330 |
Manual | 20, 12% | 50, 30% | 140,40 % |
Automation | 130,88 % | 170,70% | 190,60% |
I have created each measure for the calculation part and able to achieve as below which represents as separate entities.
Can anyone suggest how to combine two measure as to display as expected or any other option to represent in a user friendly view.
Regards
Santosh Kumar P
Solved! Go to Solution.
@SantoshKumar Use CONCATENATE or simply [Measure1] & ", " & [Measure2]
@SantoshKumar Use CONCATENATE or simply [Measure1] & ", " & [Measure2]
@Greg_Deckler I used Concatenate which it didn't worked. & worked for me but since one is a value and other is a percentage. we have to use below combination to get the desired output.