How to ignore rls on a measure

[Praveen41]

Hi all , i have a scenario we i need to compare all_zone data with zones(south , north , west, east) ,when i apply rls the all_zone measure is refering to the zone only , i could not get all_zone  value wen rls is applied on zone . by using ALL function in all_zone measure  in the report i am having date filter were it is giving total value irrespective of date filter .

any  support  on this is highly appreciated.

[v-xiaotang]

Hi @Praveen41 

I just want to confirm if you resolved this issue? If yes, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.

If you need more help, please let me know.

Best Regards,

Community Support Team _Tang

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

[tamerj1]

Hi @Praveen41 
It is difficult to understand the real problem without having the data in front of eyes. However try to
REMOVEFILTERS ( ) (remove all filters) then add VALUES ( Date ) Something like:
CALCULATE (
[Measure],
REMOVEFILTERS ( TableName ),
VALUES ( TableName[Date] )
)

[Anonymous]

Calculate the all_zone data in Power Query

[Praveen41]

Hi @Anonymous  thanks for the reply , could you please eloborate in detail how to do it & will it work when i select any particular month on the date filter 

[Anonymous]

or create calculated tables like this
tableAgg = ADDCOLUMNS(VALUES(Date[date]), "all_zone data", <expression>)

[Anonymous]

In Power Query, copy the table to a new table, grouping it by date,

Grouping or summarizing rows - Power Query | Microsoft Docs

and then the table will look like this
Date  |  All_zone Data