Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

X axis showing the wrong scale.

Hi All,
I have an issue while plotting the chart, I have created cumulative total (Running total)
based on searchpath Ids.
Here is my function which I have created to plot this chart

measure = CALCULATE(

    SUM(table[samplecount]),

    FILTER(

        ALL(table[searchpathid]),

        table[searchpathid] <= MAX(table[searchpathid])))

but I observed that some of the searchpath ids not presented in selected date but still showing me in x axis.

 


As you can see here 377 searchpath id not presented in the selected date but still showing me on x axis with wrong output.
377 presented in the other date not that date which I have selected.
How can I fix that issue?

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , Try like

     

    measure = CALCULATE(
    SUM(table[samplecount]),
    FILTER(
    ALLSELECTED(table[searchpathid]),
    table[searchpathid] <= MAX(table[searchpathid])))

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      amitchandak Thanks for your reply, No it didn't work for me still i get this 377 or other values which is not presented in perticular date.

      I tried this measure:-

      measure= CALCULATE(
      SUM(table[samplecount]),
      FILTER(
      ALLSELECTED(table[searchpathid]),
      table[searchpathid] <= MAX(table[searchpathid])))

      The dashboard is changing the values based on the date, broadcaster, series column which is
      coming from the dimension table.

      I tried referring the dim table in all filter clause and I got the relevant searchpath id
      but the cumulative was not working.