How to Filter BYPASS IN POWER BI

[panipat1990]

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

[Anonymous]

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

[Floriankx]

Hello,

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