Forum Discussion

kilala's avatar
kilala
Icon for Resolver I rankResolver I
3 years ago

How 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...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

Share some data and show the expected result.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    3 years ago

    Hi,

    Please share the PBI file as well.  Clearly show the problem there.

  • kilala's avatar
    kilala
    Icon for Resolver I rankResolver I
    3 years ago

    Hi 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's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    3 years ago

    I understand the question best only when i have some data to work with.