Forum Discussion

Kostas's avatar
Kostas
Icon for Helper IV rankHelper IV
6 years ago
Solved

Single Date filter for Multiple Columns and add Measures

Hello,  I am currently having an issue that it has to do with both, how to develop functions and how to do the calculations. I have a table that contains a unique ID and multiple column dates (see ...
Need Help
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    Hi Kostas ,

    Here is the .pbix that you can try it again: PBIX 

    Put the Date filter measure in the table visual filter and set up value as 1, put the Total measure in a card visual direcrtly and it should work fine.

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
6 years ago

Hi Kostas ,

Have you tried my sample file attached previously? This measure will work fine in the table visual. However you cannot put it in a card visual filter. Even you put it in the filter, you cannot set its value as 0 or 1 in the card visual. The card visual is not supported to put this control measure in it currently.

 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Kostas's avatar
Kostas
Icon for Helper IV rankHelper IV
6 years ago

Hey v-yingjl ,

I copied paste your measures into my pbix report. 

I placed the open in period measure as you did into the table and tried to apply filter on the table the date measure. 

When I am placing the date measure as filter I cannot change anything in the filtering or place the number ( 1 as you did).

See print screen. 

 

I just re-installed to my machine the Power BI bu still nothing. 

 

Thanks

 

  • v-yingjl's avatar
    v-yingjl
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Kostas ,

    I have modified the count measure like this:

    Total =
VAR _mindate =
    CALCULATE ( MIN ( 'Date'[Date] ), ALLSELECTED ( 'Date' ) )
VAR _maxdate =
    CALCULATE ( MAX ( 'Date'[Date] ), ALLSELECTED ( 'Date' ) )
VAR tab =
    SUMMARIZE (
        'Table',
        [ID],
        [Date1],
        [Date2],
        "Flag",
        VAR _date1 = 'Table'[Date1]
        VAR _date2 = 'Table'[Date2]
        RETURN
            IF ( _date1 < _mindate && _date2 < _maxdate, 1, 0 )
    )
RETURN
    SUMX ( tab, [Flag] )

    When you use Date filter measure to set up value as 1 in the table visual, it will show the correct result in the card visual:

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

  • Kostas's avatar
    Kostas
    Icon for Helper IV rankHelper IV
    6 years ago

    Hello v-yingjl ,

    Thanks for the help and your code.

    Indeed with the new code I was able to get the correct results in the table as it allowed me to place the filter of date in the filter section.

    Unfortunately I cannot still make the card show the correct results.

    Are you able to share the pbix file with me please?

     

    Thanks in advance 

    Kostas

  • v-yingjl's avatar
    v-yingjl
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Kostas ,

    Here is the .pbix that you can try it again: PBIX 

    Put the Date filter measure in the table visual filter and set up value as 1, put the Total measure in a card visual direcrtly and it should work fine.

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.