Dynamic Measures and to filter to a second table

[Anonymous]

Hi Power BI community,

I have managed to create a graph that uses dynamic measures successfully. What I am now struggling to do is to link this to another table which presents the same info but on row level detail.

e.g.:

I have a dynamic bar graph on the left (slicer not shown), and a table on the right. The graph and the table are supposed to reconcile (e.g. 6 records on the left for C Platt in bar format, 6 lines rows of data on the right). You can see that the table successfully filters to C Platt only but there are more than 6 records. (You can actually see that it should show the 6 records with a date in the column Last_end_Result_Date.  Null records should be filtered out)

Dynamic measure used in bar graph:

Dynamic_Measure = IF(HASONEVALUE('Dynamic Parameter'[Column1])
,SWITCH(
VALUES('Dynamic Parameter'[Column1])
,"Median Resulted Days",CALCULATE(
MEDIAN(Agreements[Days_Opened]),
FILTER(Agreements, Agreements[Last_End_Result_Date].[Date] <> blank()))

,"On Hand",CALCULATE(
COUNT(DimMatter[DimMatter_Key]),
FILTER(Agreements, Agreements[Last_End_Result_Date].[Date] = blank()))

,"Resulted",CALCULATE(
COUNT(Agreements[Last_End_Result_Date]),
FILTER(Agreements, Agreements[Last_End_Result_Date].[Date] <> blank()))
,CALCULATE(
MEDIAN(Agreements[Days_Opened]),
FILTER(Agreements, Agreements[Last_End_Result_Date].[Date] <> blank()))

))

Table:

Contains a lot of fields from the 'Agreements' Table.

I suspect the graph is not filtering out the table due to having no key in the measure. However this is not fixed even after doing a count(Key). Any ideas?

Many thanks

Kenneth Tsang

[v-yuta-msft]

Hi Oneiricer,

Column1 has values "Median Resulted Days", "On Hand" or "Resulted", right? So the "C Platt" in which column? Which column does your slicer based on? Could share more details? 

Regards,

Jimmy Tao

[Anonymous]

Hi Jimmy,

You are correct, column 1 has only 3 values.

The C Platt is in the agreements table which contains a lot of other variables. The slicer is based on Column 1 only. That table does NOT have any relationship (its only used for the slicer which in turn powers the measures to filter dynamically)