Forum Discussion
HassanI
6 years agoFrequent Visitor
Help with DAX for dynamicly sliced Average
HelloI have a table with header IDs, for each header ID there are multiple rows for each product ID, for each Header ID there is a "Status" column
I need help with DAX to Achieve the following:
- Calculate denominator by counting occurences of "Value1" & "Value2" from status column grouped by header ID
- Calculate Numerator by counting occurences of "Value1" from status column grouped by Header ID
- Calculate Numerator/Denominator grouped by header ID
- Calculate average of numerator/denominator for step 3 as its multiple values.
- be able to slice the value of 4 by date, product, country and multiple other slicers.
How can I achieve this?
1 Reply
- AnonymousNot applicable
Hi HassanI ,
Please share some dummy data with similar data structure to help us clarify your scenario and test to coding formula on it.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng