Forum Discussion
kilala
Resolver I
Resolver IHow to Filter Card based on filter in Measure
Hi all,
I have 2 measure [Balance] and [Balance LM]
I have visualise these 2 as TABLE and CARD.
In TABLE, i have following detail only:
In table, I have filtered the visua...
kilalaResolver I
Resolver IHi Ashish_Mathur ,
Sorry, the data was sensitive to be shared. I tried to create a sample as attached before but it was quite hard to make it same concept as real data.
Anyway, what I'm to achieve is to get [MTD Balance] amount BY INVOICENUMBER. and filter out those invoicenumber and [mtdbalance] where [mtd balance lm] = blank.
I have tried this before, but kept getting same result as previous data because I cannot filter out [mtd balance] = blank.
SUMX(
SuMMARIZE(vw_FactARAgeingMovement,vw_FactARAgeingMovement[InvoiceNumber],"InvNo",
CALCULATE(
sum(vw_FactARAgeingMovement[InvoiceAmount]),
FILTER(vw_DimDate,vw_DimDate[Date]<=enddate),
vw_DimInvDate, vw_DimInvDate[Date] <= enddatelm)),[InvNo])
Any idea to filter the measure?
Ashish_Mathur
Super User
Super UserI understand the question best only when i have some data to work with.