Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Ignore a filter

HI, I am working on stock report wherein I need to show different volume of stocks on two diffrent dates in one chart. For this purpose, I fetched below mentioned columns from DB.   I fetched "Q...
BI-lingual's avatar
BI-lingual
Frequent Visitor
8 years ago

Hi, can you please uplaod a sample data for more clarity?

As I understood from the description, you're using 2 quantity measure in single chart, split by same date axis, right?

Now, even if you have 2 separate date filters, but you still have a common x-axis date! Did I miss something here?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thanks Greg_Deckler for sharing thoughts on this. Here is a screenshot of sample data in database.

     

    To simplify this eqaution,  I fetched below mentioned columns from DB.

     

    • I fetched "Order Quantiy" column twice and named those columns as "Quantity1" and "Quantity2"
    • I fetched "Order Date" column twice and named those columns as "Date1" and "Date2"

    I also created two measures with following formula:

    • QuantityMeasure1 = CALCULATE(sum(Query1[Quantity1]),ALL(Query1[Date2]))
    • QuantityMeasure2 = CALCULATE(sum(Query1[Quantity2]),ALL(Query1[Date1]))

    Thanks for looking into this.