topic Calculating Daily Percentage per Floor using DAX in DAX Commands and Tips

Calculating Daily Percentage per Floor using DAX

COU_Alan — Tue, 26 Aug 2025 08:58:05 GMT

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 🙂

Re: Calculating Daily Percentage per Floor using DAX

FBergamaschi — Tue, 26 Aug 2025 09:02:35 GMT

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

Re: Calculating Daily Percentage per Floor using DAX

Anonymous — Thu, 28 Aug 2025 07:07:14 GMT

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!

Re: Calculating Daily Percentage per Floor using DAX

Anonymous — Mon, 01 Sep 2025 09:42:41 GMT

Hi COU_Alan ,

I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.

Thank you,

Tejaswi.

Re: Calculating Daily Percentage per Floor using DAX

Anonymous — Thu, 04 Sep 2025 17:45:46 GMT

Hi COU_Alan ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you,

Tejaswi.