Forum Discussion

chrismiller's avatar
chrismiller
Helper I
9 years ago

Variable Measures?

Hello first time posting,   So I have a powerBi report and wanted to creat a card that showed performance that would change depending on the month selected.   The Performance measure contains a (...
Need Help
Dog's avatar
Dog
Responsive Resident
9 years ago

Hi, 

 

hopefully I'm not confusing the issue further but as you are referring to and passing the dates for selected month do you need the relationship between selectedmonth and dimdate. 

 

if its used for other purposes would it work by passing the ALL('DimDate') into the filter of your measure to avoid the filtering when selected. 

 

NETWORK DAYS 2017_variable = CALCULATE(COUNTROWS('DimDate'),ALL('DimDate'), FILTER('DimDate', 'DimDate'[Day of Week Number] < 6),DATESBETWEEN(DimDate[Date],DATE(2017,[MonthNumSelect],1), DATE(2017,[MonthNumSelect],[EndofMonthday])))

chrismiller's avatar
chrismiller
Helper I
9 years ago

Thanks for the reply, if I am understanding your first question; I I have the relationship between selectmonth and dimdate because  the rest of the report uses dimdate and the graphs and slicers I would be using to filter this are all using dimdate; that being said I have tested and the relationship workd and the results are identical whether is filtered via dimdate or select month

 

I inserted the formula you gave and it didnt make the problem go away.  Is there something else I should change first?

  • Dog's avatar
    Dog
    Responsive Resident
    9 years ago

    hmmm that would suggest that the filter may not be responsible 

     

    if you add the networkdays measure into a card on the report page are the day numbers changing as you expect them too. 

     

     

    • chrismiller's avatar
      chrismiller
      Helper I
      9 years ago

      yes exactly! and the table below is actually much wider with several different networkdays (i just included the one for simplicity) when i change the filter all the network days change but not the formula/measure that they are in.

       

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        So... I see some bidirectional filters turned on in your model.  I trust those things just as far as I can virtually throw them.

         

        Before we debug further, you mind just turning those relationships to "Corss filter direction" = Single, instead of "Both" ?