Hi,
I have 2 field which is as below;
Type | Value |
HP | 1 |
HP | 2 |
HP | 3 |
HP | 4 |
HP | 5 |
HP | 6 |
HP | 7 |
HP | 8 |
HP | 9 |
HP | 10 |
AC | 0 |
AC | 0 |
AC | 0 |
AC | 0 |
AC | 0 |
AC | 0 |
AC | 0 |
I have a slicer for this and I want to always show AC (and its value which is zero always) iresspective of the slicer selection
Example: If I select slicer from 5 to 10, I want to show all HP values from 5 to 10 plus all AC rows as well
Is there a DAX code for this or any advance Filter options? Thanks !
Solved! Go to Solution.
Hi @Aby17,
You can take a look at the following steps if they suitable for your requirement.
1, Add an Index Column to show all AC rows at query editor side.
2, Create a calculated table:
Slicer store = DISTINCT('Type-Value'[Value])
3, Add new measure:
Measure 2 = IF ( SELECTEDVALUE ( 'Type-Value'[Type] ) = "AC", SUM ( 'Type-Value'[Index] ), IF ( SUM ( 'Type-Value'[Value] ) IN FILTERS ( 'Slicer store'[Value] ), SUM ( 'Type-Value'[Index] ), BLANK () ) )
If above doesn't work, share some sample data and expected output will be help.
Best Regards,
Jack
Hi @Aby17,
You can take a look at the following steps if they suitable for your requirement.
1, Add an Index Column to show all AC rows at query editor side.
2, Create a calculated table:
Slicer store = DISTINCT('Type-Value'[Value])
3, Add new measure:
Measure 2 = IF ( SELECTEDVALUE ( 'Type-Value'[Type] ) = "AC", SUM ( 'Type-Value'[Index] ), IF ( SUM ( 'Type-Value'[Value] ) IN FILTERS ( 'Slicer store'[Value] ), SUM ( 'Type-Value'[Index] ), BLANK () ) )
If above doesn't work, share some sample data and expected output will be help.
Best Regards,
Jack
User | Count |
---|---|
123 | |
78 | |
73 | |
70 | |
67 |
User | Count |
---|---|
106 | |
52 | |
51 | |
48 | |
48 |