Forum Discussion

anromanow's avatar
anromanow
Frequent Visitor
9 years ago
Solved

dynamicly changing result

Hi everyone, I'm new at power BI. And I have a question I had already understood that calculated tables do not respond on slicers. Here is a case: I have table, generated by sql server and imported...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi anromanow,


    Currently, calculate table cannot be dynamic changed by slicer. Slicer works on visual level, it won't participate the calculation of actual table.

     

    For example:

    Support: use slicer to filter the visual records, operate on calculation of measure.
    Not support: calculate table based on chosen of slicer.

     

    If you want to operate the current table, I'd like to suggest your take a look at below articles which about parameterized query(power query formula):

    Using dynamic parameter values in Power Query Queries

    Deep Dive into Query Parameters and Power BI Templates

     

    Regards,

    Xiaoxin Sheng

     

anromanow's avatar
anromanow
Frequent Visitor
9 years ago

Dear Anonymous

solution You gave is really obvious. I did almost the same a long time ago, when I started to learn power bi,

Actually this ^^ is not working correctly, I'll explain.

At some moment of time I want to see share of vehicle from my company in all vehicles, that counteragent =1 has ever bought.

In such case, yeah, Your solution works, and works well. And I see 30%

But couple moment later I decide to use slicer. Now I want to ignore everything except sport cars. I want to see 50%

And what about trucks? (1+1)/(1+4) I want to see  40%

Unfortunatelly in second (about sport cars) and in thid (about truck) cases I see the same 30%

table, that is calculated using summarize, is connected to source table as *:1 in both directions.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi anromanow,


Currently, calculate table cannot be dynamic changed by slicer. Slicer works on visual level, it won't participate the calculation of actual table.

 

For example:

Support: use slicer to filter the visual records, operate on calculation of measure.
Not support: calculate table based on chosen of slicer.

 

If you want to operate the current table, I'd like to suggest your take a look at below articles which about parameterized query(power query formula):

Using dynamic parameter values in Power Query Queries

Deep Dive into Query Parameters and Power BI Templates

 

Regards,

Xiaoxin Sheng

 

  • anromanow's avatar
    anromanow
    Frequent Visitor
    9 years ago

    Anonymous 

    yeah, this is exsactly waht I was talking about. 

    the only problem is time. query works about 10 min.