How to calculate percentage based on two data sources

[KarolinaZet]

Hi,

I would like to get a measure that will present the percentage of trained stores.

Data is coming from two sources:

How to get the following output that I can present in a chart?

[Syndicate_Admin · Accepted solution]

[Anonymous]

Hi @KarolinaZet 

1.You can create a calculated table first.

Country=SUMMARIZE(Source2,[Country Name])

 2.Then create a measure

Measure =
VAR a =
    CALCULATE (
        COUNT ( Source1[BAPIBUS1006_HEAD_BPARTNER] ),
        Source1[BAPIBUS1006_ADDRESS-Country] IN VALUES ( Country[Country Name] )
    )
VAR b =
    CALCULATE (
        COUNT ( Source2[Customer ID] ),
        Source2[Country Name] IN VALUES ( Country[Country Name] )
    )
RETURN
    DIVIDE ( b, a )

Best Regards!

Yolo Zhu

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

[Syndicate_Admin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[KarolinaZet]

Hi,

Please find the link to sample data here >> https://we.tl/t-aE7zUNv63n

My desired output should be as follow:

%	TRAINED / TOTAL
Belgium	33%
Poland	60%
Spain	75%
Sweden	71%
Switzerland	33%

Based on below data:

TOTAL	Count of rows
Belgium	3
Poland	5
Spain	4
Sweden	7
Switzerland	3

TRAINED	Distinct Count of rows
Belgium	1
Poland	3
Spain	3
Sweden	5
Switzerland	1

[Anonymous]

Hi @KarolinaZet 

I offered a solution above, maybe you can refer it.

Best Regards!

Yolo Zhu