Forum Discussion

Imran_1112's avatar
Imran_1112
New Member
2 years ago
Solved

Single column formula for 2 options Complete and pending

Dear All,   Need help as i am new to Power BI.   To calculate % for in single column with text of (Complete and Pending) by using slicer, click on pending on slicer will give % for pending, when ...
  • databi_nerd's avatar
    databi_nerd
    2 years ago

    Imran_1112 ,

    I believe the below measure logic will work for you and it's a dynamic logic 🙂

    Measure Logic = 
VAR __AllCount =
    CALCULATE ( COUNT ( Data[RFS] ), REMOVEFILTERS ( Data[RFS] ) )
VAR __Count =
    COUNT ( Data[RFS] )
RETURN
    DIVIDE ( __Count, __AllCount )




     

     

    If I resolve your issue please accept it as solution.
    Thanks

     

Imran_1112's avatar
Imran_1112
New Member
2 years ago

Dear Xianda Tang,

 

Thanks for your reply, Its working well but i need to update total count every time when there is new site added. In your formula /18 has to be change every time when i upload new row or the row count increase.

Is there any way where it counts automatically the total rows (in this case 18) instead of putting manual.

 

Thanks again

COUNT('Table'[RFS])/18

 

databi_nerd's avatar
databi_nerd
Frequent Visitor
2 years ago

Imran_1112 ,

I believe the below measure logic will work for you and it's a dynamic logic 🙂

Measure Logic = 
VAR __AllCount =
    CALCULATE ( COUNT ( Data[RFS] ), REMOVEFILTERS ( Data[RFS] ) )
VAR __Count =
    COUNT ( Data[RFS] )
RETURN
    DIVIDE ( __Count, __AllCount )




 

 

If I resolve your issue please accept it as solution.
Thanks

 

  • Imran_1112's avatar
    Imran_1112
    New Member
    2 years ago

    Thank you very much, it worked what i was looking for. You are amazing man.

     

    Thanks for every 1 who tried to support me.