Forum Discussion
Calculating Daily Percentage per Floor using DAX
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 🙂
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
4 Replies
- FBergamaschi
Super User
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
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!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.
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.
