Forum Discussion

Paramjit's avatar
Paramjit
Icon for Helper II rankHelper II
5 years ago
Solved

DAX Measure All Except is not working as expected

Date Category Specific Filter 01-May-21 A Great than 40 02-May-21 A Great than 40 03-May-21 A Great than 40 04-May-21 A Great than 40 05-May-21 A Great than 40 06-May-21 A Great than 40 07-May-21 A ...
Need Help
  • SivaMani's avatar
    SivaMani
    5 years ago

    Paramjit,

     

    Try the below steps,

    1. Create a table for Specific Filter (It will only have one column with 2 values)
    2. Join the new table and existing table using Specific Filter
    3. Changes the measure
    TOTAL COUNT = CALCULATE([Count],ALL('Specific Filter'[Specific Filter]))

     

    It will work.

SivaMani's avatar
SivaMani
Icon for Resident Rockstar rankResident Rockstar
5 years ago

Paramjit, Is it your requirement to calculate Category % or Specific Filter level %?

Correct me if I am wrong,

Based on the sample data, it has 31 records. Great Than 40 has 19 records. Category A has 11. 

 

Is the expected output 11/31 or 11/19?

 

 

 

  • Paramjit's avatar
    Paramjit
    Icon for Helper II rankHelper II
    5 years ago

    Thank you Sive for looking into this.

     

    Requiremnt is to calculate the % of specific filter level. 

     

    I have given the four screenshots . 

     

    first screenshot : All the values are selected in both filters. count is 31, total count is 31 and % is 100. Results are correct.

     

    Second screenshot: All the values are selected in Category filter. Only Great than 40 is selected.

    Count is  19, Total count is still 31 and % is 61.29%.  Results are correct.

     

    Third screenshot : from Category , B and C are selected. all the values are selected from sepecific filter.

    Count is 20 , total count is 20, % is 100. Results are correct.

     

    fourth screenshot: from category, B and C are selected. Less than 40 is selected. 

    Count is 12, total count is 12 and % is 100.  Resutls are not expected. count is 12 but total count should be 20 so that % should be 60. 

     

    Thank you,

    Paramjit singla