Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a measure for lookup like
LookupTown=
VAR _h=[HighestTotal]
RETURN CONCATENATEX(FILTER('tempdumpdata','tempdumpdata'[Total]=_h),'tempdumpdata'[Town],",")
here i get the list of towns like T1,T2,T3,T4....T222
I want to show the values in a visual like a table or someway easy to understand. Can you please help me in achieving it?
Solved! Go to Solution.
Hi @wheelsshark
Place the town column in a table visual then place the following measure in the filter pane of the table visual, select "is not blank" then apply the filter
TownFilter =
VAR _h = [HighestTotal]
RETURN
COUNTROWS ( FILTER ( 'tempdumpdata', 'tempdumpdata'[Total] = _h ) )
Hi @wheelsshark
Place the town column in a table visual then place the following measure in the filter pane of the table visual, select "is not blank" then apply the filter
TownFilter =
VAR _h = [HighestTotal]
RETURN
COUNTROWS ( FILTER ( 'tempdumpdata', 'tempdumpdata'[Total] = _h ) )
User | Count |
---|---|
57 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |