Forum Discussion
Solved
Best method to get a single value answer from a table.
Hello, I am new to Power BI and building DAX expressions. Excel and pivots where a lot easier but, terrible when it comes to sharing with large groups of people. I need a DAX for Dummies book. :) ...
knotpc Try this...
Create these 2 Calculated Columns
Time Period = IF( 'Table'[Date]-(TODAY()-90)>=0, "0-90 days", "Older") Transactions = CALCULATE(COUNTA('Table'[Account ID]), ALLEXCEPT('Table', 'Table'[Account ID]))and then this Measure
Measure = CALCULATE(DISTINCTCOUNT('Table'[Account ID]), FILTER('Table', 'Table'[Time Period]="0-90 days" && 'Table'[Transactions]>=2))Let me know if this works...
knotpc Try this...
Create these 2 Calculated Columns
Time Period = IF( 'Table'[Date]-(TODAY()-90)>=0, "0-90 days", "Older")
Transactions = CALCULATE(COUNTA('Table'[Account ID]), ALLEXCEPT('Table', 'Table'[Account ID]))
and then this Measure
Measure = CALCULATE(DISTINCTCOUNT('Table'[Account ID]), FILTER('Table', 'Table'[Time Period]="0-90 days" && 'Table'[Transactions]>=2))
Let me know if this works...
Sean,
I was totally stumped and your solution worked. The Transactions calculated column was the thing I kept missing.
Your awesome.