Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Getting Date Range Slicer to Play Nice with Measure

So, I'm working with a measure that takes a column with TRUE/FALSE boolean values (to track whether or not an issue was resolved), and provides the % of "TRUE" - this is accomplished using the follow...
Need Help
  • waltheed's avatar
    waltheed
    8 years ago

    Hi , 

     

    I changed the DAX formula a bit. This should work:

     

    RESOLVEDPERCENT = DIVIDE(calculate(COUNTROWS(Table1); Table1[RESOLVED] = true); COUNTROWS(Table1))

    NOT RESOLVEDPERCENT = 1 -[RESOLVEDPERCENT]

     

     

    Hope this helps. 

     

     

waltheed's avatar
waltheed
Icon for Impactful Individual rankImpactful Individual
8 years ago

Hi , 

 

I changed the DAX formula a bit. This should work:

 

RESOLVEDPERCENT = DIVIDE(calculate(COUNTROWS(Table1); Table1[RESOLVED] = true); COUNTROWS(Table1))

NOT RESOLVEDPERCENT = 1 -[RESOLVEDPERCENT]

 

 

Hope this helps. 

 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thank you! This is fantastic, and I can see what you did with the formula which should help me going forward to. I applied it to my actual dataset and it works flawlessly, this is sincerely appreciated.