The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Table - Visual 1,
Deal Stage By number of deals - Visual 2,
Deals By Dwell time - Visual 3
I have a report that shows a deal in different stages. Once the deal movers into customer it is finalized. The two visuals on the right show diffrent aggregations of the visual. I would like to hide the customer data bar unless the customer cell in the table has been clicked.
I have created a measure to hide as per 2nd visual. But I cant seem to input a swith/if statement to only show deals that are in customer stage if the customer column has been selected in the table.
Here are my Dax
dealsInProgress =
Var _count = CALCULATE(
COUNT(
dealHistory[stage]
) ,
FILTER(
VALUES( 'dealHistory'[dtStart]),
'dealHistory'[dtStart] <= MAX( 'date'[Date])
),
FILTER(
VALUES( 'dealHistory'[dtEnd]),
'dealHistory'[dtEnd]>= MIN( 'date'[Date] )
),
FILTER('dealHistory', [dtStart]<>[dtEnd]),
FILTER('dealHistory',[stage]<>"Customer")
)
return _count
allDealsMeasure dealsInProgress =
Var _count = CALCULATE(
COUNT(
dealHistory[stage]
) ,
FILTER(
VALUES( 'dealHistory'[dtStart]),
'dealHistory'[dtStart] <= MAX( 'date'[Date])
),
FILTER(
VALUES( 'dealHistory'[dtEnd]),
'dealHistory'[dtEnd]>= MIN( 'date'[Date] )
),
FILTER('dealHistory', [dtStart]<>[dtEnd]),
FILTER('dealHistory',[stage]<>"Customer")
)
return _count
I would like to do either a switch statement, or if statement, that would only customers in customer stage when the user clicks the customer column from Table 1. If customer stage has not been clicked to leave out customer. Please see below for correct action.
Correct Action: When customer cell in table 1 is not clicked
Correct Action: When customer cell in table 1 is clicked
All data is comming fro one table
I have created an if statement but it always default to false and shows whatever I put as false.
Thank you for your help 😄
User | Count |
---|---|
65 | |
61 | |
60 | |
53 | |
30 |
User | Count |
---|---|
180 | |
88 | |
71 | |
48 | |
46 |