The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi,
I am stuck in this scenario. I am trying to get percentage of a particular value in a category. I have three measure-
I am pretty sure there is some problem with my Total Customer measure but not able to get around with it.
Solved! Go to Solution.
Hi,
I was able to solve using below measure.
DOM = CALCULATE ([Total Customer], FILTER ( Contract, Contract[TARIFF_ID] = "DOM"))
Total Customer = CALCULATE(COUNT(Contract[AGREEMENT_ID]),ALLSELECTED(Contract),Contract[TARIFF_ID]="DOM")
%DM = DIVIDE ( [DOM], [Total Customer],0 )
Regards,
Supriya
Hi,
I was able to solve using below measure.
DOM = CALCULATE ([Total Customer], FILTER ( Contract, Contract[TARIFF_ID] = "DOM"))
Total Customer = CALCULATE(COUNT(Contract[AGREEMENT_ID]),ALLSELECTED(Contract),Contract[TARIFF_ID]="DOM")
%DM = DIVIDE ( [DOM], [Total Customer],0 )
Regards,
Supriya
User | Count |
---|---|
16 | |
8 | |
6 | |
6 | |
5 |
User | Count |
---|---|
23 | |
13 | |
13 | |
8 | |
8 |