Forum Discussion

DataGeek16's avatar
DataGeek16
Frequent Visitor
8 years ago
Solved

DAX Subquery For Stacked Bar Chart

Need help in converting the following code to DAX to use in a stackedbarchart visual value.   Select Sum(A) FROM (   Select SUM(EventCount) as A, DNSName        FROM Testtable         GROUP BY ...
Need Help
Show and Tell
Tips and Tricks
  • popov's avatar
    popov
    8 years ago
    Sorry, below correct formula
    Measure = IF( CALCULATE ([Distinct Users], ALL( Testtable[DNSName] ) ) > 20 , SUM ( Testtable[EventCount] ) )
DataGeek16's avatar
DataGeek16
Frequent Visitor
8 years ago

popov

I get this error when I try to build the measure. 

 

Please note that [Distinct Users] is a calculated field/measure. 

 

Error:

"The True/False expression does not specify a column. Each True/False expressions used as a table filter expression must refer to exactly one column."

popov's avatar
popov
Resolver III
8 years ago
Sorry, below correct formula
Measure = IF( CALCULATE ([Distinct Users], ALL( Testtable[DNSName] ) ) > 20 , SUM ( Testtable[EventCount] ) )