Power BI measure not showing values as per Slicer selection

[Anonymous]

I have created a Measure with some calculations as below to get the total Revenue amount for Azure products and the measure is giving the correct values.

FY21RevImpact_Azure = CALCULATE((1+CALCULATE([GrowthRate],WCF_FX_MX[FXFilter]="AZURE",ALLEXCEPT(WCF_FX_MX,WCF_FX_MX[Billing Currency]),ALLSELECTED(WCF_FX_MX)))*AVERAGE(WCF_FX_MX[CloudFXChange])/100*[RevbasebyCurrency_Azure])

But when i select any specific billing currency then the measure does not show any values.

The measure is not working as per the slicer selection.

Please advice a solution 

[Icey]

Hi @Anonymous ,

It's best to create a dummy .pbix file for test. Please remove sensitive information. It is suggested to upload your file to OneDrive for Business and then paste the link here.

Best Regards,

Icey

[amitchandak]

@Anonymous , refer if these can help

currency
https://www.youtube.com/watch?v=4dosxfNxR6M
https://www.sqlbi.com/articles/currency-conversion-in-power-bi-reports/
https://radacad.com/currency-converter-power-bi-function-part-1
https://www.youtube.com/watch?v=Q4hF4CwJsFEhttps://radacad.com/currency-exchange-rate-conversion-in-power-bi-with-live-rates-part-2
https://businessintelligist.com/2015/03/17/power-bi-tutorial-how-to-implement-currency-conversion-using-power-query-and-power-pivot/
https://blog.beyondimpactllc.com/blog/building-a-dynamic-currency-converter-with-power-bi

If Not

Can you share sample data and sample output in table format?