% Between two columns. How to get card to show total of filtered value?

[edavis248]

When dividing to get percentage between two columns and show percentage in it s own column. to show this vlaue in a card. How do I get the card to show total of filtered value?

The total is reflecting in the table but the card is showing the summed value not the total fitlered value shown in the chart.

[v-henryk-mstf · Accepted solution]

Hi @edavis248 ,

Do you mean that the total percentage value of the filtered statistics is not consistent with the actual percentage? 

Maybe you can try below formula:

Filter_result_ =
VAR div2 =
    CALCULATE ( SUM ( FactInternetSales[SalesAmount] ), ALL ( DimProduct ) )
RETURN
    DIVIDE ( SUM ( FactInternetSales[SalesAmount] ), div2, BLANK () )

If the problem is still not resolved, please provide detailed error information and test data. Looking forward to your reply.

Best Regards,
Henry

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

[amitchandak]

@edavis248 , Total of filtered value

calculate(Sum(Table[Value]), allselected())

without filter

calculate(Sum(Table[Value]), all())

[edavis248]

Thank you, I tried this but the value is not the same as the % of total column or a percentage?