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

is the select month in a filter on the report page. 

 

if so can you try changing the ALL('DimDate') to ALL('SelectMonth')

 

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

 

although I'm still not entirely sure I follow.... and no doubt am probably frustrating you further 

 

 

chrismiller's avatar
chrismiller
Helper I
9 years ago

no frusteration at all. this report has sent me sideways.

 

these might explain it

 

NETWORK DAYS 2017_variable2 and 3 are the two formulas you provided.

 

When nothing is selected they all show the default value for april (first in the list and with 20 days) with the exception of the one which is sorted by month number so 21 days in january.

 

They are all slightly different formulas but essientially functionally identical.

 

one slicer is for dimdate and the other is for selectmonth