Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Create a Measure using a two different filtered visual

Hi All,   Trying to work this out for quite a while, i have two visuals with different slicers for filtering, i would like to be able to use the output from the filtered viusals in another measure ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi _AAndrade  Thanks for your support, please find the link to pbix file not able to upload due to restrictions in place.

 

Variance Calc.pbix

_AAndrade's avatar
_AAndrade
Resident Rockstar
2 years ago

Hi Anonymous,

Take a look to the pbix file i'm attaching and see if this is what you're looking for.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hello _AAndrade 

     

    The variance% should come as 78%

     

    However as per the .pbix you shared this is 60%

     

    Basically if you remove the measure and use the measur Weekly Baselines you in the visual it will give you a value of all the count didvided by the Unique months. What i would need is extract 355 and 1625 and store and make the required calculations. Hope that help

     

    • _AAndrade's avatar
      _AAndrade
      Resident Rockstar
      2 years ago

      Hi Anonymous,

      Now I think the results are correct. Please take a look at this new pbix.