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.