Forum Discussion

COU_Alan's avatar
COU_Alan
Frequent Visitor
1 year ago
Solved

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 d...
  • FBergamaschi's avatar
    FBergamaschi
    1 year ago

    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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.