dax to show count of all the percentages together

[Anonymous]

hi i am looking for dax to show count of all the percentages together

i have my p1%,p2%,p3% calalutions done but separtely.

now i am trying to display all the p1%p2%p3% together as single count.

[PhilipTreacy]

Hi @Anonymous 

The information you've provided doesn't make the issue very clear. 

Can you please provide your PBIX.  What percentages are you talking about?  How do you calculate them? Please show some data and code.

Phil

[Anonymous]

[v-henryk-mstf]

Hi @Anonymous ,

Try the below formula:

count =
VAR p1_sla =
    IFERROR ( ( 'Table'[P1 HIF OF LIDL] / [P1 Count] * 100 ), 100 )
VAR p2_sla =
    IFERROR ( ( 'Table'[P2 HIF OF LIDL] / [P2 Count] * 100 ), 100 )
VAR p3_sla =
    IFERROR ( ( 'Table'[P3 HIF OF LIDL] / [P3 Count] * 100 ), 100 )
RETURN
    p1_sla + p2_sla + p3_sla

If it is not the result you want to count, can you provide detailed information and expected results so that I can do further testing?

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

hi henryk

i tried your formula but not geeting the current count.

my result after applying your query is 46.73

where my individual p1 is 100 p2 is 99.68 and p3 is 100

could you plz help me