Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

ignore RLS for a aggregated measure

HI    I HAVE A PBIX FILE I CAN SEND TO YOU IF YOU WANT A TEMPLATE    I have a aggreate  sum measure that dosent work as entented after i apply RLS Sales amount= sum(sales)   before RLS is appl...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

do you have a sample of the code. I will for sure look into the function and try to solve my problem with calculatetable

AilleryO's avatar
AilleryO
Icon for Memorable Member rankMemorable Member
4 years ago

Hi,

Here is the code to create my consolidated table :

Nb Products (%age byOrigin) =
VAR ListCountry =TREATAS(VALUES(Products[Origin]),Products[Origin])//Create list with level of conso you need
VAR NbProducts =COUNTA(Products[SKU_Number])//Count of product number/ref
RETURN
FILTER(SUMMARIZECOLUMNS
(
ROLLUPADDISSUBTOTAL
(
Products[Origin], "IsCountruSubTotal", ListCountry ),//Create sub totals
"Share in %", //Name of column created
DIVIDE(COUNTA(Products[SKU_Number]),NbProducts )),//Calculation of %age
NOT(ISBLANK(Articles[Origine]))//option (Filter to get rid of blanks)
)

And then I create my visuals based on this table, and not on the original one.


Let us know