I'm not able to do pick a column name when doing a measurement and it greys out suggesting that i'm not able to use it.
My formula is =
events in progress =
CALCULATE(
COUNTROWS('public 10-bookgirl';
FILTER('public 10-bookgirl'[start 2]; <= MAX('Date Range'[DateTime]));
FILTER('public 10-bookgirl'[end 2] = BLANK() || ('public 10-bookgirl'[end 2] > MAX( 'Date Range'[DateTime]))
)
start 2 and end 2 is showing up grey even though it is the correct column name please advise.
Solved! Go to Solution.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsRegards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCheck out new user group experience and if you are a leader please create your group
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.
User | Count |
---|---|
410 | |
157 | |
107 | |
80 | |
57 |
User | Count |
---|---|
418 | |
173 | |
132 | |
108 | |
86 |