Forum Discussion
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 ...
- Sorry, below correct formula
Measure = IF( CALCULATE ([Distinct Users], ALL( Testtable[DNSName] ) ) > 20 , SUM ( Testtable[EventCount] ) )
Hello, DataGeek16
Converted formula in DAX below
Measure =
SUMX (
ADDCOLUMNS (
VALUES ( Testtable[DNSName] ),
"A", CALCULATE ( SUM ( Testtable[EventCount] ) )
),
[A]
)
But this formula have same behavior
Measure = SUM ( Testtable[EventCount] )
Please, explain yor issue in more detail
Try this approach
Measure = IF( CALCULATE ([Distinct Users], ALL( Testtable[DNSName] ) > 20 ), SUM ( Testtable[EventCount] ) )
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."
