Table showing same value for all

[abukapsoun]

Hi, 

I have a measure calculated based on multiple formula called Value. in the same table there is country column as well. 

When I create a slicer with country, and when I change the country, the Value displayed is correct, however when I select multiple countries, it is calculating the SUM of it and displaying it at every row. 

Example 1

Example 2

Now This what I get when I select both of them, 

How can I fix that?

Thanks,

[abukapsoun]

hi @Jihwan_Kim May I ask you for one more support please? When I add the column subtotal column, it is giving me the value of last day. Is there a way where i can display the sum or country growth in the column subtotal? 

in fact now we are displaying the growth per day for each country, I am keen to add the total growth over that period of tiem in the column subtotal. 

thank you again

[Jihwan_Kim]

Hi,

I am not sure how your measure is authored, but I guess it looks something like below.

new measure =
CALCULATE ( [Expressionmeasure], 'tablename'[columnname1] >= 1 )

Please try to use a keepfilters dax function and check whether it suits your requirement.

new measure =
CALCULATE ( [Expressionmeasure], KEEPFILTERS ( 'tablename'[columnname1] >= 1 ) )

[abukapsoun]

Hi, 

It didn't work. the columnname1 is what? is it the country column? and expressionmeasure is the value?

thanks,

[Jihwan_Kim]

Hi,

Please share your sample pbix file's link (onedrive, googledrive, dropbox, or any other link) here, and then I can try to look into it.

Thanks.

[abukapsoun]

Hi @Jihwan_Kim 

Thank you for proposing. Here is my dataset

https://drive.google.com/file/d/1-IKTlebQWjZcAJIrbQeECTkS4_puWrBP/view?usp=share_link

Looking forward 🙂

Thanks

[Jihwan_Kim]

Hi,

Thanks for sharing the link. I just checked and the link needs access code.

[abukapsoun]

Sorry, can you try now 

https://drive.google.com/file/d/1-IKTlebQWjZcAJIrbQeECTkS4_puWrBP/view?usp=share_link

[Jihwan_Kim · Accepted solution]

Hi,

Please check the attached pbix file whether it suits your requirement.

I changed some measures to show the numbers.

Thank you.

[abukapsoun]

I Can't thank you enough!!! It is working as expected! 

One last thing if possible, How can I sort the table to show the highest RoDiff during this day? 

I tried the sorting option but it doesn't look correct

[Jihwan_Kim]

Hi,

I am not sure if I understood correctly your last question, but please check the attached pbix file whether it suits your requirement.

[abukapsoun]

IT WORKS LIKE CHARM!! Thank you very much!