Forum Discussion

insandur's avatar
insandur
Icon for Helper II rankHelper II
1 year ago

Measure not working when using in table when other columns added in the table and applied filters

Hi Experts ,   I have table with multiple columns and using measure to get previous month value for selected month "Prev month Qty"   Now this measure doesnot work in the table when i add f...
Need Help
insandur's avatar
insandur
Icon for Helper II rankHelper II
1 year ago

Thank You Yolo,

i tried above method, even this is giving me blank values when i apply filter 'Approval Status' column. I get correct numbers when no filter is applied. Attaching the BI sample file.

  

 

after the filter

 




Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi insandur 

Thank you for your quick reply. Could you provide some sample data? Because I cannot create some sample data according to your description, so I can't provide you with more suggestions and solutions.

 

Best Regards!

Yolo Zhu