Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Parameters

Hi community,

I have a table that has a measure with a parameter in order to modify the table in the filter context, 

I need to count the numbers of rows , distinct count others columns, etc in the table but the problem is , only I can count these when the parameters is off (equal to cero) , but when I change this the table is filtered ok , but I can´t count any rows or columns whith a measure .

Can you help me about this ?

 

This is ok situation with the parameter in 0 and the count of rows (3 anomalias) is counting the rows of the table. 

 

Anomalias = 

CALCULATE(
DISTINCTCOUNTNOBLANK(YR_CONSUMOS_EXTENDIDA[ID_extendida])
)

This is the DAX expresion that count in the table YR_CONSUMOS_EXTENDIDA

But when apply the parameter (in this case 5%) to modify the context the table is filtered ok (with filter context) but I need to create a new DAX formiula in order to count the columns or rows in the new filter.

The actual formula only count the phisical table but when you apply the parameter I can not count this modification so In this case I need to see 2 Anomalias instead of 3

 

 

 

 

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

     

    Based on the information you provided, the problem you are having is that you are unable to calculate rows or columns when you make changes to the parameters. The dax formula you provided seems to be correct, but I would need more data to determine if it fits your data model.

    Providing more detailed information will allow us to better understand your needs and better accomplish your purpose.

     

    How to Get Your Question Answered Quickly - Microsoft Fabric Community

    If it does not help, please provide more details with your desired out put and pbix file without privacy information.

     

    Best Regards,

    Ada Wang

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