Replace measures used in Multiple visuals and Pages in Power BI desktop

[abhiigt]

Hi Folks,

I have a .pbix file containing multiple visuals and pages, almost 90 % of visuals use a Measure A, This Measure A needs to be replaced by Measure B. I need a way to do it dynamically instead of manually. As the datasource is cube, creation of columns in not possible and creating new measure would require multiple approvals. 

So please let me know incase there is someway to do it.

Thanks

[Syndicate_Admin]

Don't @abhiigt,

Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.

Best regards
Qin eyelids

[Syndicate_Admin]

Don't @abhiigt,

Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.

Best regards
Qin eyelids

[Anonymous]

Hi @abhiigt ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it.

Best Regards,
Eyelyn Qin

[Anonymous]

Hi @abhiigt ,

How about using SWITCH() to select measures via slicer like this:

Measure =
SWITCH (
    MAX ( 'ForSlicer'[Measure Type] ),
    "Measure A", [Measure A],
    "Measure B", [Measure B]
)

More:

https://exceleratorbi.com.au/edit-replace-code-inside-all-dax-measures-using-tabular-editor/

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.

[themistoklis]

Hello @abhiigt ,

I beliveve you have to make the relevant changes in the back end. Meaning either in Power Query Editor or in the cube in SQL Server.

You you need to check which fields the measure is using. Then change these fields to the ones you want either in Power Query Editor or in cube in SQL Server