Forum Discussion

Nimai123's avatar
Nimai123
Post Patron
5 years ago
Solved

Dynamic Measure and Slicer

Hello Guys,   I want to create a dynamic measure which depends on the slicer.   When I select 19-20 my measure will show the data for that year When I select 20-21 my measure will show the...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Nimai123 , for that you can add isfiltered or hasonevalue 

     

    Volume KL Dynamic19-20 =
    var _cnt = countx(filter(allselected('Calendar'[FY],'Calendar'[FY] ="19-20"),'Calendar'[FY])+0
    return
    IF(_cnt >0 && isfiltered ('Calendar'[FY]) ,CALCULATE( SUMX(GRINetSalesDetailsBI,GRINetSalesDetailsBI[NetSales]/1000) ,'Calendar'[FY] = "19-20" ),BLANK())

Nimai123's avatar
Nimai123
Post Patron
5 years ago

Hello amitchandak 

 

Yes, I am hiding and showing based on the selection in the slicer and each line is a measure.

 

When I am not selecting any year from the slicer I should get a blank result, but I am getting both the lines by using the above measures

 

When I select 1 year I should get one line and when 2 I should get 2 lines and so on...

 

 

 

amitchandak's avatar
amitchandak
Super User
5 years ago

Nimai123 , for that you can add isfiltered or hasonevalue 

 

Volume KL Dynamic19-20 =
var _cnt = countx(filter(allselected('Calendar'[FY],'Calendar'[FY] ="19-20"),'Calendar'[FY])+0
return
IF(_cnt >0 && isfiltered ('Calendar'[FY]) ,CALCULATE( SUMX(GRINetSalesDetailsBI,GRINetSalesDetailsBI[NetSales]/1000) ,'Calendar'[FY] = "19-20" ),BLANK())