Forum Discussion

abukapsoun's avatar
abukapsoun
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, t...
Need Help
  • Jihwan_Kim's avatar
    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.

     

Jihwan_Kim's avatar
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 ) )