Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Range Creation with filter and all except

Hi Team,   I was trying to create a bar chart with the range on X axis.   The SQl query is as below: select count( distinct [COMPANY_NAME]) total,'Range:0-50K' as range from ( select sum(amount...
Need Help
  • dax's avatar
    dax
    6 years ago

    Hi Anonymous , 

    You could remove this in filter and try to refer to my sample for details.

    Best Regards,
    Zoe Zhi

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

  • dax's avatar
    dax
    6 years ago

    Hi Anonymous , 

    I think you need to use [TO_CCY]  from summarize table(my Table 2) in slicer  instead of from fact table. If you want to use this field from fact table(Table(2) in my sample), I think you need to create relationship between two tables based on [TO_CCY] .

    Best Regards,
    Zoe Zhi

    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
6 years ago

Hi, 

 

Thank you so much for the help this is giving me exactly what i was expecting.

But i have one issue, the TO_CCY should not be included in the filter, i have a slicer with multiple currency when i select them the bucket should filter accordingly.

is that possible?

dax 

dax's avatar
dax
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous , 

You could remove this in filter and try to refer to my sample for details.

Best Regards,
Zoe Zhi

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
    6 years ago

    Hi dax 

     

    I did try that and got an output , this output should change when i apply the currency filter but i see that it doesnt change. 

    When i used USD in the DAX it showed count 23 when i remove it the count was 25.

    I used TO_CCY from FACT table as slicer and selected USD but this dint change from 25 to 23.

     

    Thanks in advance