Forum Discussion

zkurdi's avatar
zkurdi
Regular Visitor
8 years ago

Filter Based on Multi User Selected Values

Hello New to PowerBi here so i apoloigze if this has been posted before, but i've tried searching for few days now with no luck   So I have PowerBi read a table from Jira. Key columns are Created...
Need Help
zkurdi's avatar
zkurdi
Regular Visitor
8 years ago

Hello MFelix

 

Thanks for the update. I've added an example above. I'll need to give the users the abilty to drill down and see actual records, so sum and count. while they would work fine usually, user wont be able to see records.

 

Can i also ask you please for the value (i.e. why use) VAR in a measure ?

 

Many thanks in advance

 

MFelix's avatar
MFelix
Super User
8 years ago

Hi zkurdi,

 

Add a Calendar table to your model not related with any of your columns then add following measure to your model:

 

Count_Project = 
VAR Last_Date =
    MAX ( DimDate[Date] )
RETURN
    CALCULATE (
        COUNT(Tickets[Ticket #] );
        Tickets[Closed] <= Last_Date
    )

Add this measure as a filter to your table when is greater than 0 should filter out your information:

 

 

Regarding you question on the Max part I use a variable in order to have values inputed on the measure, On the formula we are filtering out all the dates that are lower than the selected date you can't use a MAX function directly on the calculated filter part so using a variable you are able to make it pass the parameter you need.

 

 

Regards,

MFelix

  • zkurdi's avatar
    zkurdi
    Regular Visitor
    8 years ago

    Hello MFelix

     

    Many thanks for your reply. I've tried to replicate this but it did not seem to work. I've addded a link to the image showing what my current dashbaord looks like and the modifications i'm trying to impement

     

    link: https://drive.google.com/file/d/1lyEFdlCbvWgo1IFsl_U8UjGkl0cbHSnB/view <it seems i'm unable to attach to this reply or display image from this link>

     

    Ideally, it would be best if i can create a view (filtetered table) based on the user selected year and month and then display data from that table the report

     

    Thanks

    Z.K.

     

     

     

     

    • MFelix's avatar
      MFelix
      Super User
      8 years ago

      Hi zkurdi,

       

      The issue with your setup is that you are using the week number on your information that works at a differente level.

       

      Can you give a sample of the information that you are using just to make a simulated file and get you a setup of the visual?

       

      Regards,

      MFelix