Forum Discussion

Post Patron

3 years ago

Solved

Table showing same value for all

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,

Jihwan_Kim
3 years ago
Hi,

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

I changed some measures to show the numbers.

Thank you.

Test.pbix2.2 MB

11 Replies

Jihwan_Kim
Super User
3 years ago
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
  Post Patron
  3 years ago
  Hi,
  
  It didn't work. the columnname1 is what? is it the country column? and expressionmeasure is the value?
  
  thanks,
  - Jihwan_Kim
    Super User
    3 years ago
    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
Post Patron
3 years ago
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