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
kilala's avatar
kilala
Icon for Resolver I rankResolver I
3 years ago

hi HiraNegi ,

I have tried that measure but i am still getting same result as before. I think because i didnt cooperate the filter that i put in table.

 

In my table, filter I put is:

-invoice number not blank

-Balance LM not blank and not 0.

 

Any idea to incorporate this into the measure?

Many thanks

 

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?