March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi Team,
I stuck to one scenario. which is when I select more than one in a slicer, it is not working. Below, I list out the details.
I have one disconnected table, like below.
using this table to control a measure using dax
1. Based on grade I have 1 measure [MaxSalaryByGrade].
2. Based on the function, I have 1 measure [MaxSalaryByFunc].
3. Based on the OU I have 1 measure [MaxSalaryByOU].
Now I create another measure to interact with the measure using the above table, like Below.
but this measure does not display any value. why it began like this.
how to achieve this goal.
Thanks in advance.
Solved! Go to Solution.
@Vallirajap , try like
Max = SWITCH( TRUE(),
countrows(interset(values('Currency'[Index]), {4,6})) =2, [MaxSal_G&O],
SELECTEDVALUE('Currency'[Index]) =4, [MaxSalaryByGrade],
SELECTEDVALUE('Currency'[Index]) =5, [MaxSalaryByFunc],
SELECTEDVALUE('Currency'[Index]) =6, [MaxSalaryByOU])
@Vallirajap , try like
Max = SWITCH( TRUE(),
countrows(interset(values('Currency'[Index]), {4,6})) =2, [MaxSal_G&O],
SELECTEDVALUE('Currency'[Index]) =4, [MaxSalaryByGrade],
SELECTEDVALUE('Currency'[Index]) =5, [MaxSalaryByFunc],
SELECTEDVALUE('Currency'[Index]) =6, [MaxSalaryByOU])
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
91 | |
90 | |
83 | |
73 | |
49 |
User | Count |
---|---|
167 | |
149 | |
98 | |
73 | |
57 |