Forum Discussion

ewuchatka's avatar
ewuchatka
Icon for Helper II rankHelper II
8 years ago

Count if with existing measure

Hello   I've had almost a year-long break from Power BI  and I've tried to look for the answer on the forum but without any luck. I would appreciate your help.   I am trying to recreate COUNT IF ...
Need Help
ewuchatka's avatar
ewuchatka
Icon for Helper II rankHelper II
8 years ago

 Ashish_Mathur

Thanks

 

I'm not sure what I am doing wrong I created a calendar table with three columns (it is the first calendar table I ever created!?):

Date = CALENDAR (DATE(2000,1,1), DATE(2025,12,31))

Week Number = WEEKNUM('Date'[Date])

Year = YEAR('Date'[Date])

 

 

Then not sure but this formula doesn't work...

=COUNTROWS(FILTER(SUMMARIZE(Calendar[Week Number],[Week Number],"ABCD",[AUP]),[ABCD]>1))

 

 

Thanks


Ewa

 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

Share the link from where i can download your PBI file.

  • ewuchatka's avatar
    ewuchatka
    Icon for Helper II rankHelper II
    8 years ago

    Hello Ashish_Mathur

     

    Thank you for you help! Is this what you need?

     

    https://app.powerbi.com/groups/me/reports/2ecf1648-c49e-45d9-8506-bcea705d08b8?ctid=2fc13e34-f03f-498b-982a-7cb446e25bc6

     

    I also insert elow of a screenshot in excel where you can see - when I filter on "Agra" manufacturer in excel I need just "1" in WoD but in Power BI there is "2". Formula used in excel is =COUNTIF(B5:B8,"<1.00")

     

    I'd like the calculation to work  whenever I filter manufacturer/account/packtype etc like in excel

     

    pbi

     .

    Thanks

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

    No.  I need to download your PBI file.  Upload it to Google Drive/One Drive and share the download link.  Also, i do not see any image in your previous message.