Forum Discussion
DAX Subquery For Stacked Bar Chart
- 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
Thanks for the quick response.
You are right, this doesn't solve my issue.
Essentially, I have two KPI values - One for distinct users and the Second one for the total number of page hits done by each of those users when they access the websites. I have other filters corresponding to Country, User Outlets, etc. in my dataset.
On the PBI chart I also have a stacked bar chart that displays the website name and the page hits like the one below.
Users, Page Hits and Stacked Bar Chart
- Criteria is that when the distinct count of users go below 20 I shouldn't display anything. That's easy and I have done it using a IF clause.
However, when the count of distinct users is > 20, PBI still checks for data within each row of the stacked bar chart and if the distinct users for a particular site falls below 20, it doesn't display anything. In this scenario, I want it to check for the total sum of event counts for all the sites together instead of doing the check on one particular website.
Please advise.