percentage measure is not correct

[NISHA_S]

this is a sample report contain some columns...In measure i have two types of calculation values ....count values plus precenatge values...If the category is percentage of total ,Measure will be percenatge values else count values...ie...I faced a problem while calcualting percentage ....If type is Concrete Sapiens, i want to calcualte percentage based on the

count of concrete ->sapiens(8) /count of combined ->sapiens (18) ....currently my perecnatge calcualtion is not correct....Is it possible?

[V-pazhen-msft · Accepted solution]

@NISHA_S 
You can create the following measure using format(), see attached pbix for detail.

Measure =
var concrete_sapiends_percent = FORMAT(MAX([Count])/CALCULATE(SUM('Table'[Count]),FILTER(ALL('Table'),[Type]="Sapiens")),"Percent")
Return IF(MAX('Table'[Type])="Concrete Sapiens",concrete_sapiends_percent,MAX('Table'[Count])

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Please provide sample data in usable format (not as a picture) .