Forum Discussion
JustinDoh1
5 years agoPost Prodigy
My calculation does not work using variable (row context issue or something else?)
I am sharing my Pbix file here. I posted a similar question yesterday, but this is little bit different (because I am trying to see whether somehow my logic has an error: ex "vNotElig...
- 5 years ago
How about this for the variable:
Var vNotEligibleStep1 = COUNTROWS( FILTER( Data, Data[Consent] = "Not Eligible" && Data[Step] = 1 ) )This will return 1 for each row which meets the filtered criteria. You can now keep the switch function clause.
- 5 years ago
Alternatively you can try:
new measure = SUMX(Data, [Step 1_0819])
Anonymous
5 years agoNot applicable
But Michael Jackson???