Forum Discussion
The data for some years dissapeared.
Hi Anonymous ,
It seems that your measure is wrong
The ) is in the wrong place, please modify:
Measure = IF(ISFILTERED('suppliers'[name]), Calculate(sum(contract[contruct_amount])), CALCULATE(sum(contract[contruct_amount]),FILTER('suppliers', [id]= "070440006322")))Or if you are still confused about it, please provide me with more details about your table and your expected outputs or share me with your pbix file after removing sensitive data.
Refer to:
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
It seems that your measure is wrong
The ) is in the wrong place, please modify:
Measure = IF(ISFILTERED('suppliers'[name]), Calculate(sum(contract[contruct_amount])), CALCULATE(sum(contract[contruct_amount]),FILTER('suppliers', [id]= "070440006322")))
Or if you are still confused about it, please provide me with more details about your table and your expected outputs or share me with your pbix file after removing sensitive data.
Refer to:
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.