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] ) )
popov's avatar
popov
Resolver III
8 years ago

DataGeek16

Try this approach
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] ) )
    • popov's avatar
      popov
      Resolver III
      8 years ago
      Distinct Users is measure as you described
    • DataGeek16's avatar
      DataGeek16
      Frequent Visitor
      8 years ago

      That's awesome! This works well for my first scenario. I will test it with the other two scenarios and let you know if I have any further issues. 

       

      popov- Just to enhance my understanding, what is this measure doing differently that wasn't possible with the direct filtering? Please explain and thanks a bunch.