Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DAX Calculation Help with filters on visual

I have the following data, by day. this is an example of Multiple days data.    Moment call_id call_time Widget b 4509105517166590 4/15/2021 Widget a 4505281519878140 4/15/2021 Wi...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous,

     

    Accoriding to my understanding, you want to get dynamic count and percentage based on selected values in slicer(Moment and Date), right?

     

    I have done it with creating a new table using the following formula:

    NewTable = DISTINCT(SELECTCOLUMNS('Table',"Product",[Moment]))

     

    Then please try these:

    how many times = IF(MAX('NewTable'[Product]) in ALLSELECTED('Table'[Moment]),CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[Moment]=MAX('NewTable'[Product]))),0)+0
    total items = CALCULATE(COUNTROWS('Table'),FILTER('NewTable','NewTable'[Product] =MAX('Table'[Moment])))
    % on order = DIVIDE([how many times],[total items])

    The final output is shown below:

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

so I wouldn't want the total items to change with the item filter, just with the date filter. 

 

so for example with 4/15 and 4/16 sleceted and  Accessory a selected I would see

 

Accessory A

how many times = 2

total item = 8

Wendeley-North's avatar
Wendeley-North
Icon for Resolver I rankResolver I
5 years ago

Not the best at this, but you could try:


total orders = SUMX ( ALLEXCEPT(ordertable, ordertable[call_time]), DISTINCTCOUNT( ordertable[call_id] ) )