Calculating Daily Percentage per Floor using DAX

[COU_Alan]

Hi guys

I want to calculate percentage per floor by daily

As you can see in below image, i set 6 slicers (a table's column1, b tables's col1 ...)

And for calculating percentage, i want to set daily total value in below chart regardless of floor (values in redboxes should be same)

Please excuse the incomplete nature of the image.

Security measures have been applied via masking in case of unforeseen circumstances.

Thank you 🙂

[v-tejrama]

Hi @COU_Alan ,

Thank you @FBergamaschi  for the response provided!

Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Thank you for your understanding!

[FBergamaschi]

Hi @COU_Alan,

to obtain the same value you need to ignore filters

In the below image you provided

can you please psecify what is in cloumns in the top matrix? Suppose it is a column named Table[Column] and your measure is called Amount

I suggest you to create a measure like this

Amout no Filter = 
CALCULATE ( [Amount], REMOVEFILTERS ( Tables[Column] ) )

If you have more than one column in the columns section of the matrix, you need to remove filters also from them

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI