how to get actual effected data from Column chart with 2 measures and month with measure values.

[Arons]

Hi All,

i need your input and guidance for below scanrio/

I have colum 2 visual.

1. Column chart, with Datemonth , with 2 measures. as 

2. simpel table visual with name [column]

when i click the any one of measures values, i was expected it will filter the 2nd visual name list. however it only showing data filtered by Datemonth field.

is it possible to get calculated measure values from visual 1 , of its filtered data in 2 nd visual ?

the drill through not helping me, as i wanted in the same page and like to see the actual table rows/name[column] list of the measure is calculated agains.

[Arons]

Any one has idea, how to get the measure data filter the table.

[Arons]

Thanks Denis, please find below visual and data used.

i have given details table, and i am trying to filter only the measure either false/true and see the below name list filtered accordingly, however this only filters on month level and shows data.

pls check and add your inputs. thanks

measure(False) = CALCULATE(SUM(Details[Points]),Details[Status] = False)

measure(True) = CALCULATE(SUM(Details[Points]),Details[Status] = True)

NamePointsStatusDate

Adam	100	True	1/1/2022 12:00:00 AM
betty	98	False	1/1/2022 12:00:00 AM
Sam	98	True	1/1/2022 12:00:00 AM
Cindy	102	False	2/1/2022 12:00:00 AM
Daniel	101	True	2/1/2022 12:00:00 AM
Ricky	101	False	2/1/2022 12:00:00 AM
eva	99	False	4/1/2022 12:00:00 AM
Francis	89	True	4/1/2022 12:00:00 AM
ketty	89	True	4/1/2022 12:00:00 AM
nike	89	True	4/1/2022 12:00:00 AM

[v-chenwuz-msft · Accepted solution]

Hi @Arons ,

Please drag the point field to the Y-axis of this clustered column chart than two measures.

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Arons]

Thanks Chenwuz,

my requirements is to have measures filters working. for example, i have given simple measure which has false or true, in real requirements, we would be having complex dax which shows values, 

of corresponding values, if we wanted the underlying table rows, how to achive. like customer repeating with more thanx,  with many conditions, i might have created couple measures for trend analysis, 

to get actual details, put this requirements.

[selimovd]

Hey @Arons ,

the behavior depends on the data model.

Can you create an example file? Then it's easier to help you.

Best regards

Denis

[Arons]

Thanks Denis, please find below visual and data used.

i have given details table, and i am trying to filter only the measure either false/true and see the below name list filtered accordingly, however this only filters on month level and shows data of name , points,,etc.

is it possible when i click within month, either false/measure value to get correponding result in below table. as it only shows month wise still, 

pls check and add your inputs. thanks

measure(False) = CALCULATE(SUM(Details[Points]),Details[Status] = False)

measure(True) = CALCULATE(SUM(Details[Points]),Details[Status] = True)

NamePointsStatusDate

Adam	100	True	1/1/2022 12:00:00 AM
betty	98	False	1/1/2022 12:00:00 AM
Sam	98	True	1/1/2022 12:00:00 AM
Cindy	102	False	2/1/2022 12:00:00 AM
Daniel	101	True	2/1/2022 12:00:00 AM
Ricky	101	False	2/1/2022 12:00:00 AM
eva	99	False	4/1/2022 12:00:00 AM
Francis	89	True	4/1/2022 12:00:00 AM
ketty	89	True	4/1/2022 12:00:00 AM
nike	89	True	4/1/2022 12:00:00 AM