Forum Discussion
DataGeek16
8 years agoFrequent Visitor
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 ...
- 8 years agoSorry, below correct formula
Measure = IF( CALCULATE ([Distinct Users], ALL( Testtable[DNSName] ) ) > 20 , SUM ( Testtable[EventCount] ) )