sames formulas but get different result

[ngocnguyen]

Hi, 

I have 1 PBI , in which there is 2 card that use the same dax but get different results.

Card 1: PSV total: 2.30 Bn   ( Calculate all SMS amount) 

Card 2: Without RAC : 1.86 Bn   ( Calculate SMS amount that excluding RAC)

I saw that both card use the same formulas SMS Amt. 

So, Could you please explain how to do that

[ryan_mayu · Accepted solution]

@ngocnguyen 

hope this is helpful.

https://docs.microsoft.com/en-us/power-bi/consumer/end-user-report-filter

[amitchandak · Accepted solution]

@ngocnguyen , I think the lesser one has a visual level filter. can you check that.

refer:https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-report-add-filter

https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-report-filter

[mahoneypat]

Two potential explanations - 1. One of the cards has a filter on in in the Filter panel (expand it on the right and highlight the cards to check). 2. The two cards respond differently because of the interactions are set differently with other visuals (highlight a visual, click on Format in toolbar and enable Edit Interactions to check).

Regards,

Pat

[ngocnguyen]

hI @mahoneypat ,

Yes, It seems that 1. One of the cards has a filter in the Filter panel is the correct. So could you please instruct me how to change the Filter panel for a card in PBI?

[ryan_mayu · Accepted solution]

@ngocnguyen 

hope this is helpful.

https://docs.microsoft.com/en-us/power-bi/consumer/end-user-report-filter