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
Anonymous's avatar
Anonymous
Not applicable
9 years ago

I feel you are working way too hard on this :)

 

Your MonthSelect table already has a MonthNumber and MonthDate (start of month).  

 

MonthNumSelect could be just MIN(MonthSelect[MonthNumber]) ... no?

 

I would add EndOfMonth and NetworkDays as calculated columns on your MonthSelect table, and write really simple measures based on that...

chrismiller's avatar
chrismiller
Helper I
9 years ago

MIN(MonthSelect[MonthNumber]) is pretty much functionally identical to the one I have ... as when the filter is on it will display only the month filtered.  

 

However still causes the same problem in my 'WFP YTD ration" being off (except the new number is slightly different as it reflects januarys network days)

 

I made the calculated columns but cannot put them into the measure as it doesnt refer to a min max etc

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Can you add a screen shot of your model relationships?

     

    Not sure how DimDate/MonthSelect and your fact table relate.

    • chrismiller's avatar
      chrismiller
      Helper I
      9 years ago

      sure no problem, hope this helps.

       

      • 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])))