Forum Discussion

panipat1990's avatar
panipat1990
Icon for Helper III rankHelper III
8 years ago

How to Filter BYPASS IN POWER BI

Dear Team,

 

I am new in POWER BI TOOL. i have a requirement. I made a report. MY Requirement is 

I want to BYPASS Filter Day Number.

Code    Sale

1           100

2           200

3           300

4           400

5           500

 

When i Select Year Month And Day....

I Want to When i Select Day then No Effect of this report.Means i want to By Pass Day Number in Measure..

My Measure is Sum(Table(Sale))

 

What Should i do for donot effect of selection of day....Kindly help me its very urgent

Need Help

2 Replies

  • Floriankx's avatar
    Floriankx
    Icon for Solution Sage rankSolution Sage
    8 years ago

    Hello,

     

    Measure_AllDays:=CALCULATE([Measure],ALL(Table[DateNumber]))

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI panipat1990,

     

    Can you explain more detail about your requirement ?(e.g expected result)  Do you mean enable filter effect only on measure not visual?

     

    If this is a case, you can take a look at below formula.

    Sample =
CALCULATE ( SUM ( Table[Sale] ), Table[Code] = DAY ( TODAY () ) )

     

    Regards,

    Xiaoxin Sheng