Forum Discussion

AlaIssa's avatar
AlaIssa
Frequent Visitor
2 years ago

Dynamic Measure - Target switch and Calculation

Dear All, I would appreciate your kind help on the below: I want to create dynamic target measure; I have table contains the below data  Col1 Tgt1 Col2 Tgt2 Col3 Tgt3 A1 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi AlaIssa ，

Please check if this is your expected output:

If not, please consider providing a test file without private information.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

AlaIssa's avatar
AlaIssa
Frequent Visitor
2 years ago

Thank you so much for the help

I am attaching the link, I have created 3 visiuals and 3 slicers , what I want is when I select slicer1 (col1) the data of target in visual 2 and visual 3 should be changed as per slicer1 selection 

 

Example: if I select slicer1 (C1) , the target in visiual2 for Col2 data should be 100 and the target for visiual3 for col3 data should be 100. 

if I select Col3 (Cl3) , the target in visiual2 for Col2 data should be 90 and the target for visiual1 for col1 data should be 90. 

which I want dynamic target based on slicer selection and default value as an example = 99

 

data are all in 1 table 

thanks a lot for the support 

 

demo.pbix

  • AlaIssa's avatar
    AlaIssa
    Frequent Visitor
    2 years ago

    Any idea how can I manage this scenario?