Trouble calculating Percentage based on Card

Question

Hello team BI,&nbsp;I have a problem with percentage calculationI made 2 slicers with:&nbsp;-&nbsp;Date sent Quote:&nbsp;that interact with QUOTE AMOUNT ISSUED and NB QUOTE ISSUED-&nbsp;Order Date:&nbsp;that interact with QUOTE AMOUNT EARNED and NB QUOTE EARNED and both Transformation QuoteI have the correct data with amount &amp; nd but not Transformation with the count of percentageClearlly,&nbsp;170/375 = 45%&nbsp;and not&nbsp;84%&nbsp;as shown in Bi.I found out, that in percentage Bi didn't took the filtred data shown in card but the whole table data.The dax used to calculate Percentage:&nbsp;Transformation quote (%nb) =DIVIDE(&nbsp; &nbsp; [NB QUOTE EARNED],[NB QUOTE ISSUED],0&nbsp; &nbsp; )with:&nbsp;NB QUOTE EARNED = CALCULATE(COUNTROWS('BDD TRY'),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'BDD TRY'[POINTAGE]="Transféré"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )+0AndNB QUOTE ISSUED = CALCULATE(&nbsp; &nbsp; COUNTROWS('BDD TRY')+0)&nbsp;&nbsp;&nbsp;POINTAGETYPE&nbsp;PRICE HT €DATE SENT QUOTEORDER DATE&nbsp;Maintenance&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 72,416.16 €14/09/202208/09/2021TransféréMaintenance&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,290.50 €27/01/202228/01/2022&nbsp;Travaux&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 930.00 €07/02/202210/02/2022TransféréTravaux&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,863.10 €02/02/202210/02/2022TransféréTravaux&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; €07/02/202210/02/2022&nbsp;Maintenance&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,860.00 €10/02/202216/02/2022TransféréTravaux&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6,437.80 €25/01/202217/02/2022TransféréTravaux8,604.20 €12/01/202218/02/2022TransféréTravaux&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,257.50 €13/01/202218/02/2022TransféréTravaux667.60 €11/02/202221/02/2022

amitchandak · Answer

BI_ITEMS , Try measure like 
&nbsp;
nb quote earned = CALCULATE(COUNTROWS('BDD TRY'),'BDD TRY'[POINTAGE] = "Transféré")
nb quote issued = CALCULATE(COUNTROWS('BDD TRY'))
Transformation quote (%nb) = DIVIDE([nb quote earned],[nb quote issued],0)

bi_items · Answer

Hello!Thanks for your reply!However, I aleardy apply those measure but same probleme.&nbsp;&nbsp;&nbsp;

Forum Discussion

Trouble calculating Percentage based on Card

2 Replies

Related content

Trouble Calculating Percentage Difference

Calculate Percentage

Trouble with % of Total calculation

Calculating Percentages

Data Ingestion Troubles

POINTAGE	TYPE	PRICE HT €	DATE SENT QUOTE	ORDER DATE
	Maintenance	72,416.16 €	14/09/2022	08/09/2021
Transféré	Maintenance	1,290.50 €	27/01/2022	28/01/2022
	Travaux	930.00 €	07/02/2022	10/02/2022
Transféré	Travaux	1,863.10 €	02/02/2022	10/02/2022
Transféré	Travaux	- €	07/02/2022	10/02/2022
	Maintenance	1,860.00 €	10/02/2022	16/02/2022
Transféré	Travaux	6,437.80 €	25/01/2022	17/02/2022
Transféré	Travaux	8,604.20 €	12/01/2022	18/02/2022
Transféré	Travaux	1,257.50 €	13/01/2022	18/02/2022
Transféré	Travaux	667.60 €	11/02/2022	21/02/2022