Forum Discussion

orghn's avatar
orghn
Helper I
4 years ago

Error while filtering on slicer

Hi Everyone!   I have 2 tables, one with products and the other with laboratories. I need that both blank spaces have the value of the middle one (1514).   The measure is: Precio_Mio = CALCULAT...
Need Help
v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

Hi orghn ,

 

In the table you provided, unlink the Lab table from the Product table. Then try the following formula:

My_Price =
VAR sel_lab =
    SELECTEDVALUE ( Lab[Lab Name] )
RETURN
    CALCULATE (
        SUM ( 'Price'[Price] ),
        ALLEXCEPT ( 'Price', 'Price'[Month] ),
        sel_lab = 'Product'[LabName]
    )

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your feedback.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago

Hi @Syndicate_Admin Thanks for your reply. I can´t unlink the Lab table and the Product one because in my real file I need both. Is there any other solution?