Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Hide values with calculate

Hi people, 

 

Im new in power bi and have a couple of questions with my data model, its very simple,

 

I have the following measure to retrieve only Argentina Sales as you can see on "Visual A", I dont have a DimTable for countries.

 

My question is, is there a way to show only the data of the country (or element in any other situation) that im filtering with CALCULATE as in "Visual C" or "Visual D"?

 

Thank you

 

 

 

 

 

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    For Visual C just make a measure saying if(selectedvalue(country)="Argentina",sum(sales),blank and in tick the dropdown just select(show items with 0 data) and for visual D just untick this checkbox.

     

     

2 Replies

  • CNENFRNL's avatar
    CNENFRNL
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Hi, Anonymous , you might want to try

    = CALCULATE ( [Total Sales], KEEPFILTERS ( FactTable[Country] = "Argentina" ) )
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    For Visual C just make a measure saying if(selectedvalue(country)="Argentina",sum(sales),blank and in tick the dropdown just select(show items with 0 data) and for visual D just untick this checkbox.