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
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