Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I have table :
Table_A
Client | Type | Category | Value |
Client A | A | AA | 10 |
Client B | B | AA | 15 |
Client B | A | AB | 8 |
Client C | C | AC | 5 |
Client A | D | AB | 13 |
Client D | E | AD | 4 |
Client E | F | AE | 7 |
Table_B ( duplicate from Table_A, remove other column except column Type, and set only specific Type )
Type |
B |
C |
E |
Table_A & Table_B have relationship many to one based on column Type
For visual I want to add slicer for column Type ( Multiselect ) and chart data based on Category.
Slicer Type ( from Table_A )
------------
A
B
C
D
E
F
I have measure in Table_A to detect slicer Type when selected ( True / False ).
How to create a measure based on measure I've made,
when slicer Type is not selected, chart data only show default data based on all type in Table_B,
and when slicer Type is selected single or multiple, chart data show based on selected.
Any Suggestion?
Solved! Go to Solution.
After trying several times,
when using your measure, it's actually correct. but there is a little bug when using isfiltered. isfiltered will return true when nothing is selected (don't know how).
I finally combined your measure with measure I've made and make some changes.
Measure :
After trying several times,
when using your measure, it's actually correct. but there is a little bug when using isfiltered. isfiltered will return true when nothing is selected (don't know how).
I finally combined your measure with measure I've made and make some changes.
Measure :
@gzai , Try a measure like
Filtered Type = if(ISFILTERED(Table_A[Type]) , CALCULATE(count(Table_A[Type]), ALLSELECTED(Table_A[Type])) ,
CALCULATE(count(Table_A[Type]), filter(Table_A , Table_A[Type] in Table_B[Type])))
Hi @amitchandak ,
I have tried measure
Filtered Type = if(ISFILTERED(Table_A[Type]) , CALCULATE(count(Table_A[Type]), ALLSELECTED(Table_A[Type])) ,
CALCULATE(count(Table_A[Type]), filter(Table_A , Table_A[Type] in Table_B[Type])))
error "A single value for column 'Type' in table 'Table_B' cannot be determined. ..."
@gzai , Try like
Filtered Type = if(ISFILTERED(Table_A[Type]) , CALCULATE(count(Table_A[Type]), ALLSELECTED(Table_A[Type])) ,
CALCULATE(count(Table_A[Type]), filter(Table_A , Table_A[Type] in allselected(Table_B[Type]))) )
@amitchandak measure no error, but it seems for else logic is not correct.
Visual chart when no selected filter :
Total Value = 62 ( 10 (A) + 15 (B) + 8 (A) + 5 (C) + 13 (D) + 4 (E) + 7 (F) )
expected results when no selected filter :
Total Value = 24 ( 15 (B) + 5 (C) + 4 (E) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |