Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Pankaj_Jangra
New Member

selecting values from slicer & get the calculated table filtered

Hi ,

I am trying to resolve a issue in which i have to use Table functions :-

1st :- taking out invoices of one date using table functions ( as measure gives only a scalar output)
2nd :- taking out invoices of other date using table functions 
3rd :- Except(2nd,1st)
4th :- storing as a calculated table 

but now requirement is that we need to give dynamic slicer for dates, & it will give me the invoices for those 
, so my overall requirement is to use slicer at front end and by which i should change my calculate table .
is this possible ?

1 REPLY 1
v-shex-msft
Community Support
Community Support

Hi @Pankaj_Jangra,

Power bi does not support to create dynamic calculated column/table based on filter effects. They not work on the same data level and you can't use the child level to affect its parent.

Notice: the data level of power bi(from parent to child level)

Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.