Forum Discussion

Harom's avatar
Harom
New Member
1 year ago
Solved

Calculation based on 2 or more variables (slicer/parameter?)

Hi, I'm new to Power BI, but not with data. I've been searching the web and this forum for the following, but without success sofar: I'm looking for a way to get a calculation Sales Period Currency...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Harom 
    Thank you for reaching out microsoft fabric community forum.
    could you please provide some sample data.so that we can look into it more effienciently.
    Thank you.

HarishKM's avatar
HarishKM
Icon for Super User rankSuper User
1 year ago

Harom Hey,
you can create your all measure then create a field parameter for the same as below image.

 


expected output as below.

 

 

 

 

Thanks
Harish M
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

 

Harom's avatar
Harom
New Member
1 year ago

HarishKM That could be an option, but we want to combine currencies and periods and with preferably one parameter/slicer for each variable, to keep it maintainable.
3 currencies x 6 different periods for at least 4/5 measures