Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a Visual like below, Whenever the Select Store and Division will filter out -Table column Store and Division only need to filter and Overall need not to be filter.
Overall Fields needs to remain same eventhough if we filter anything .It will not take any filter.Please help here.
Thanks,
Mohanraj
@amitchandak@Jihwan_Kim @Fowmy
Solved! Go to Solution.
Hi @mogunase1 ,
Based on my test, you need to create a new table for slicer like this:
ForSlicer = DISTINCT(SELECTCOLUMNS('Table',"Select Store",[Store],"Division",[Division]))
Then create a flag measure (when values matched , set as 1):
Flag = IF(MAX('Table'[Store]) in ALLSELECTED('ForSlicer'[Select Store]) && MAX('Table'[Division])in ALLSELECTED('ForSlicer'[Division]) ,1)
Now could find the matched row according to the flag measure:
Store Measure = CALCULATE(MAX('Table'[Store]),FILTER('Table',[Flag]=1))
Division Measure = CALCULATE(MAX('Table'[Division]),FILTER('Table',[Flag]=1))
The final output is shown below:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @mogunase1 ,
Based on my test, you need to create a new table for slicer like this:
ForSlicer = DISTINCT(SELECTCOLUMNS('Table',"Select Store",[Store],"Division",[Division]))
Then create a flag measure (when values matched , set as 1):
Flag = IF(MAX('Table'[Store]) in ALLSELECTED('ForSlicer'[Select Store]) && MAX('Table'[Division])in ALLSELECTED('ForSlicer'[Division]) ,1)
Now could find the matched row according to the flag measure:
Store Measure = CALCULATE(MAX('Table'[Store]),FILTER('Table',[Flag]=1))
Division Measure = CALCULATE(MAX('Table'[Division]),FILTER('Table',[Flag]=1))
The final output is shown below:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Thanks for your help.
But in this case all the 3 measure are based on same filed .
Dax are -
3.) Overall ---- I need to Calculate D.Count of Incident id without any filter.
This 3 i need to mention in same table.
If i filter Store and Division , Store and Division measure only need to change and Overall measure always needs to be same.
Please help here.
Thank you.
Hey @mogunase1 ,
I gave you a proposal for measure 3 [Overall].
Did you try that? Did it work?
Best regards
Denis
Hi ,
You gave me this,
My Overall Measure = CALCULATE( SUM( myTable[Overall] ), ALL( StoreTable[Store] ), ALL( DivisionTable[Division] ) )
But there is no Column like Store and Division.Not able to create Cal.Column also.
All the 3(Store,division and Overall) based on calculation of single column (#Incident id column)
So i tried below , but doesnt work.
Overall = CALCULATE(DISTINCTCOUNT(Table[Incident ID]),ALL(Table[Incident ID]))
Thanks,
Mohanraj
Hi,
Slicers are based on column.
For Overall as you mentioned i put
Hey @mogunase1 ,
what is the "Status" we see in the table? This should not disappear.
Can you share the file with me? It seems easier to take a look directly in your data.
Best regards
Denis
Hey @mogunase1 ,
in the overall measure you have to exclude the slicers for Store and Division. Try the following approach:
My Overall Measure =
CALCULATE(
SUM( myTable[Overall] ),
ALL( StoreTable[Store] ),
ALL( DivisionTable[Division] )
)
User | Count |
---|---|
94 | |
77 | |
71 | |
62 | |
58 |
User | Count |
---|---|
110 | |
103 | |
84 | |
65 | |
62 |