Forum Discussion

justinMcC's avatar
justinMcC
Frequent Visitor
8 years ago
Solved

Measure to x axis chart or dymanic table

Hi,     I have a using a table, measure and slicer to categorise my data. I need to create a chart showing the result of measure, which I need to update when user changes value of slicer. Below is...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    justinMcC,

    I make the following  table using your sample data.


    Create the following measures in the first table.
    Measure  = IF(MAX(Table1[Min_eligibe])<MAX(Table2[Column1]),"partical","full")
    partical = CALCULATE(COUNTROWS(Table1),FILTER(Table1,Table1[Min_eligibe]<MAX(Table2[Column1])))
    full = CALCULATE(COUNTROWS(Table1),FILTER(Table1,Table1[Min_eligibe]>=MAX(Table2[Column1])))

    Create visuals as shown in the following screenshot.


    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

justinMcC,

I make the following  table using your sample data.


Create the following measures in the first table.
Measure  = IF(MAX(Table1[Min_eligibe])<MAX(Table2[Column1]),"partical","full")
partical = CALCULATE(COUNTROWS(Table1),FILTER(Table1,Table1[Min_eligibe]<MAX(Table2[Column1])))
full = CALCULATE(COUNTROWS(Table1),FILTER(Table1,Table1[Min_eligibe]>=MAX(Table2[Column1])))

Create visuals as shown in the following screenshot.


Regards,
Lydia

justinMcC's avatar
justinMcC
Frequent Visitor
8 years ago

Thanks Anonymous

 

I used a modified version of your DAX formula. It worked great, thanks for your help - it really helped me out with customer issue